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 vote239 views1 answer
Check if program is running vbnet
VBA
1 vote239 views1 answer
Excel vba array remove first
VBA
0 vote248 views1 answer
Visual stuiod not recognising desgined labels
VBA
0 vote265 views1 answer
Vba cell all borders
VBA
0 vote246 views1 answer
Find if year is leap year vb
VBA
2 votes215 views1 answer
Vba array contains
VBA
0 vote264 views1 answer
.net crash app
VBA
4 votes217 views1 answer
Excel formula for last non-empty cell in a column
VBA
0 vote234 views1 answer
Dlete rows with blanks and space " " vba
VBA
3 votes237 views1 answer
Extract the nth word from a text string
VBA