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 vote209 views1 answer
Excel vba existence of a file
VBA
22 votes289 views1 answer
Excel vba check if directory exists
VBA
5 votes230 views1 answer
Vba low word from Long Integer
VBA
3 votes232 views1 answer
Vba not equal
VBA
1 vote221 views1 answer
Sort using vba
VBA
0 vote245 views2 answers
VB
VBA
0 vote221 views1 answer
Excel vba protect content
VBA
0 vote227 views1 answer
System.Runtime.InteropServices.COMException: 'Call was rejected by callee. (Exception from HRESULT: 0x80010001
VBA
0 vote232 views1 answer
Excel vba join variant array
VBA
0 vote222 views1 answer
Loop through lines in text file vb net
VBA