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 votes334 views2 answers
Excel vba last column with data
VBA
0 vote350 views1 answer
Find database connection string vb
VBA
0 vote327 views1 answer
Vbscript check if string is empty
VBA
0 vote340 views1 answer
Vba check 32 or 64 bit
VBA
0 vote348 views1 answer
Date as number vb
VBA
0 vote309 views1 answer
Vb.net round to 2 decimal places
VBA
1 vote354 views1 answer
Excel vba Populating a combobox on a userform from a range of cells
VBA
0 vote318 views1 answer
Vb net dgv doesn't keep currency format
VBA
1 vote294 views1 answer
Ms access open form to new record
VBA
0 vote311 views1 answer
Excel vba populate array with cell values
VBA