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 votes403 views1 answer
Xlvba double quotes in string literal
VBA
0 vote442 views1 answer
Excel vba delete columns in range
VBA
0 vote336 views1 answer
Vba format currency
VBA
0 vote376 views1 answer
Vba min
VBA
0 vote359 views1 answer
VBA Sleep Snippet
VBA
5 votes426 views1 answer
Excel vba get low byte from INTEGER
VBA
0 vote333 views1 answer
Docker vboxmanage not found
VBA
3 votes360 views1 answer
Extract the nth word from a text string
VBA
0 vote353 views1 answer
Excel vba cell on change
VBA
0 vote404 views1 answer
Excel web scraping
VBA