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 vote183 views1 answer
How to extract a file from an ISO:
VBA
0 vote189 views1 answer
Refresh token em vb net
VBA
5 votes202 views1 answer
Excel vba second byte from INTEGER
VBA
0 vote182 views1 answer
Excel vba scroll to cell
VBA
0 vote198 views1 answer
Regex numeric digits
VBA
0 vote239 views1 answer
Vba line feed
VBA
1 vote204 views1 answer
Vba format string as cash
VBA
4 votes190 views2 answers
Vba create folder if not exist
VBA
0 vote195 views1 answer
How to get the value of optionbutton in vba
VBA
0 vote142 views1 answer
Vbide vbproject reference
VBA