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

1 vote360 views1 answer
Vba reverse string
VBA
0 vote363 views1 answer
Show unix time in vba
VBA
0 vote350 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA
0 vote354 views2 answers
Excel vba protect cells with formula
VBA
0 vote378 views1 answer
Vbnet find highest value in chart
VBA
0 vote385 views1 answer
Vba random number
VBA
3 votes356 views2 answers
Excel "vba" match last value
VBA
0 vote359 views1 answer
Vbnet line graph smooth lines
VBA
0 vote381 views1 answer
Loop through each cell in dgv vbnet
VBA
1 vote365 views1 answer
Vba date to unix timestamp
VBA