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

1 vote339 views1 answer
Add rows to datagridview vb.net
VBA
0 vote374 views1 answer
Como ler subitem de um array em json usando vbnet
VBA
0 vote328 views1 answer
Vba paste values
VBA
1 vote304 views1 answer
Vba exit do while
VBA
0 vote368 views1 answer
Excel delete ever other vba
VBA
5 votes918 views1 answer
Vlookup vba
VBA
2 votes324 views1 answer
Vba array contains
VBA
1 vote326 views1 answer
Vba declare api 64 bit 32 bit
VBA
0 vote336 views1 answer
Limit combobox to list vba
VBA
0 vote335 views1 answer
Vb run command
VBA