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 vote168 views1 answer
Vba change named range address
VBA
0 vote194 views1 answer
Vba search string position
VBA
0 vote175 views1 answer
Vbnet check if number is even or odd
VBA
1 vote166 views1 answer
Excel vba get ordinal number from cardinal number
VBA
0 vote196 views1 answer
Search for text in every worksheet excel visual basic
VBA
1 vote166 views1 answer
Vba declare api 64 bit 32 bit
VBA
1 vote172 views1 answer
Vba delete file
VBA
31 votes339 views1 answer
Excel vba function to convert column number to letter
VBA
8 votes327 views1 answer
Vba make a short integer from two bytes
VBA
0 vote179 views1 answer
Label de tableau dans des label.text en VBA
VBA