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 vote221 views1 answer
Prive sub enter clicked vb
VBA
0 vote216 views1 answer
Find control with name vb
VBA
0 vote207 views1 answer
Vba len variant
VBA
0 vote212 views1 answer
Excel vba clear filter
VBA
0 vote198 views1 answer
Vbnet check if string is only symbols
VBA
0 vote213 views1 answer
Excel run macro every 5 minutes
VBA
0 vote211 views1 answer
Excel vba protect content
VBA
8 votes218 views1 answer
Excel vba make integer
VBA
0 vote201 views1 answer
Vba pass named range to function
VBA
0 vote230 views1 answer
Sort dictionary by key vba
VBA