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 vote127 views1 answer
Excel vba join variant array
VBA
0 vote146 views1 answer
Excel vba set cell value to empty
VBA
0 vote141 views1 answer
Excel vba textbox forecolor disabled
VBA
0 vote156 views1 answer
Excel vba protect shapes
VBA
0 vote138 views1 answer
Vbnet check if string is only numbers
VBA
2 votes135 views1 answer
Vba ado ace sql alias ignored for calculated column
VBA
1 vote135 views1 answer
Vbs run
VBA
-1 vote131 views1 answer
Vba code to add new column in table
VBA
0 vote143 views1 answer
Vbnet click on dgv cells
VBA
3 votes140 views1 answer
Vba continue for each loop
VBA