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 vote200 views1 answer
Vba select file in folder
VBA
-1 vote238 views1 answer
Vba code to add new column in table
VBA
0 vote232 views1 answer
Vba DisplayGridlines
VBA
1 vote231 views1 answer
Add control vb
VBA
-1 vote241 views1 answer
VBA check if a cell contains a letter or string
VBA
0 vote243 views1 answer
Vba test optional argument
VBA
1 vote234 views1 answer
Excel vba unload userform
VBA
0 vote245 views1 answer
Vba collection contains
VBA
15 votes280 views1 answer
Excel vba wait
VBA
0 vote219 views1 answer
Excel vba hide columns
VBA