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 vote252 views1 answer
Vba userform textbox wrap text
VBA
0 vote206 views1 answer
Test if form is open vb
VBA
0 vote213 views1 answer
Vba string start with
VBA
0 vote216 views1 answer
Vbnet revrese the order of character in string
VBA
0 vote218 views1 answer
Excel vba copy range with filter
VBA
0 vote198 views1 answer
Docker vboxmanage not found
VBA
20 votes516 views1 answer
Excel vba factorial
VBA
1 vote202 views2 answers
Vba function return array
VBA
0 vote231 views1 answer
Vba code to select image in sheet
VBA
0 vote227 views1 answer
Excel vba ternary
VBA