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

5 votes175 views1 answer
Excel vba right word from Long Integer
VBA
1 vote176 views1 answer
Vb.net get name by Cell Click
VBA
0 vote162 views1 answer
Selecttoken em vbnet e json
VBA
0 vote164 views1 answer
Vbnet check if sting contians symbols
VBA
5 votes167 views1 answer
Excel vba low word from Long Integer
VBA
0 vote157 views1 answer
How to extract a file from an ISO:
VBA
0 vote165 views1 answer
Vbnet round to nearnest thousand
VBA
0 vote207 views1 answer
Visual basic cmd
VBA
1 vote170 views1 answer
Excel vba last row of range
VBA
0 vote163 views1 answer
Search in richtextbox vb.net
VBA