Excel vba combine ranges

With Sheet1
Set rng1 = .Range("A1:A3")
Set rng2 = .Range("C1:C3")

'This combines the two separate ranges, so select A1, A2, A3, C1, C2, C3
set newRng = Union(rng1, rng2)

'This combines the two ranges in the same way as when using "A1:C3", 
'so including the cells from column B
set newRng = .Range(rng1, rng2)

Similar codes

0 vote180 views1 answer
Vba min
VBA
0 vote174 views1 answer
Remove series name from legendvbnet
VBA
0 vote178 views1 answer
VBA is form loaded
VBA
0 vote179 views1 answer
Thread sleep vb
VBA
0 vote173 views1 answer
Vb.net change cursor to wait
VBA
0 vote165 views1 answer
Vbnet chart make 0 gridline line different color
VBA
0 vote178 views1 answer
Vba variable number of arguments
VBA
1 vote159 views1 answer
Vba declare api 64 bit 32 bit
VBA
0 vote150 views1 answer
Style percent not found vba
VBA
0 vote179 views1 answer
.net dark title bar
VBA