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 vote119 views1 answer
Get month number from month name vbnet
VBA
0 vote116 views1 answer
Excel named range sum
VBA
18 votes174 views3 answers
Excel-vba make integer
VBA
0 vote131 views1 answer
Vba test optional argument
VBA
0 vote132 views1 answer
Vba excel parser xml
VBA
0 vote135 views2 answers
Checking and changing system volume vb.net
VBA
0 vote118 views1 answer
Pivot data source not accepting table named range vba
VBA
0 vote130 views1 answer
Regex numeric digits
VBA
0 vote129 views1 answer
Vba remove numbers from string
VBA
0 vote131 views1 answer
Convert Seconds to HH:MM:SS in VB.Net
VBA