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 vote154 views1 answer
Limit combobox to list vba
VBA
0 vote158 views1 answer
Vba integer to double
VBA
1 vote149 views1 answer
Excel vba compare 2 rows
VBA
1 vote162 views1 answer
Excel vba array remove first
VBA
0 vote155 views1 answer
Send text to clipboard vb.net
VBA
0 vote162 views1 answer
Sendkeys vba selenium
VBA
0 vote156 views1 answer
Excel vba calculate
VBA
0 vote158 views1 answer
Add text to combobox drop down vb
VBA
1 vote160 views1 answer
Shortcut to apply a formula to an entire column in excel
VBA
0 vote186 views1 answer
Amd64 vs arm64 linux
VBA