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

2 votes185 views1 answer
Vba ado ace sql alias ignored for calculated column
VBA
0 vote195 views1 answer
Vba count all row
VBA
-1 vote173 views1 answer
For i in range vba
VBA
0 vote170 views1 answer
Excel vba disable copy paste
VBA
2 votes175 views1 answer
Excel vba date to string conversion
VBA
0 vote175 views2 answers
Excel vba prevent save
VBA
0 vote184 views1 answer
Send text to clipboard vb.net
VBA
0 vote186 views1 answer
Dlete rows with blanks and space " " vba
VBA
20 votes244 views1 answer
Excel vba recursive example factorial function
VBA
0 vote130 views1 answer
How to make a if statement with vbs
VBA