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

4 votes346 views1 answer
Excel vba how to programmatically remove the marching ants after range copy
VBA
0 vote363 views1 answer
Vba variable number of arguments
VBA
0 vote361 views1 answer
Vbnet check if string is only letters
VBA
0 vote354 views1 answer
Excel vba ternary
VBA
5 votes379 views1 answer
Excel vba right word from Long Integer
VBA
3 votes335 views1 answer
Vba make long from two shorts
VBA
5 votes339 views1 answer
Excel vba how to unit test vba code
VBA
0 vote325 views1 answer
Vb test if reference is null
VBA
1 vote334 views1 answer
Excel vba make cell visible
VBA
0 vote358 views2 answers
Delete all controls from list of control vb.net
VBA