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 vote212 views1 answer
Excel vba populate array with cell values
VBA
0 vote219 views1 answer
Vba static variable
VBA
0 vote244 views1 answer
Visual stuiod not recognising desgined labels
VBA
1 vote235 views1 answer
How to remove zeros in excel
VBA
0 vote238 views1 answer
Excel vba first working day month
VBA
0 vote225 views1 answer
Switch pictures with buttons vb.net
VBA
3 votes241 views1 answer
Vba continue for each loop
VBA
0 vote229 views1 answer
Show unix time in vba
VBA
-1 vote249 views1 answer
Vba sendkeys
VBA
0 vote244 views1 answer
Columns dont autoresize on program start vb.net
VBA