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 votes181 views1 answer
Excel vba tool to help with refactoring code
VBA
3 votes216 views2 answers
Excel "vba" match last value
VBA
0 vote211 views1 answer
Visual basic cmd
VBA
0 vote161 views1 answer
Vb net show lines for all axis labels in chart
VBA
0 vote159 views1 answer
Vba test optional argument
VBA
0 vote161 views1 answer
Vba dropdown event
VBA
1 vote172 views1 answer
Excel vba array remove first
VBA
20 votes337 views1 answer
Excel vba factorial
VBA
31 votes288 views1 answer
Excel-vba how to convert a column number into an excel column
VBA
1 vote163 views1 answer
Vba refresh pivot table
VBA