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 vote248 views1 answer
Add text to Shape VBA
VBA
4 votes241 views2 answers
Excel vba last column with data
VBA
3 votes258 views1 answer
Vba request json
VBA
5 votes262 views1 answer
Excel vba first byte from INTEGER
VBA
0 vote240 views4 answers
How to continue formula in below line in vba code
VBA
0 vote231 views1 answer
Vb get ip address
VBA
1 vote231 views1 answer
Vba declare api 64 bit 32 bit
VBA
-1 vote235 views2 answers
How close excel through visual basic
VBA
5 votes262 views1 answer
Excel vba tool to help with refactoring code
VBA
0 vote246 views1 answer
Vba array dimensions
VBA