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 vote298 views1 answer
Vba excel do not recalculate before save
VBA
5 votes335 views1 answer
Excel-vba get integer high byte
VBA
0 vote301 views1 answer
Send webhook vbscript
VBA
0 vote290 views1 answer
Convert unix to date vba
VBA
2 votes304 views1 answer
Excel vba check if string entirely alpha
VBA
0 vote284 views1 answer
Telephon call in vba
VBA
0 vote291 views1 answer
Vbnet make a string to unicode converter
VBA
0 vote326 views1 answer
Excel vba protect scenarios
VBA
0 vote298 views1 answer
Write listbox to text file vb.net
VBA
0 vote288 views1 answer
Vba collection key list
VBA