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 vote274 views1 answer
Excel vba formatconditions positive
VBA
0 vote263 views1 answer
Vb net show lines for all axis labels in chart
VBA
15 votes369 views1 answer
Excel vba wait
VBA
0 vote280 views1 answer
Excel vba hide gridlines
VBA
0 vote279 views1 answer
Refer to resource using string variable vb.net
VBA
0 vote282 views1 answer
.net crash app
VBA
6 votes308 views1 answer
Excel vba get the path of current workbook
VBA
0 vote260 views1 answer
Vba get text file content
VBA
0 vote300 views1 answer
Vba boolean to string
VBA
18 votes400 views2 answers
Vba make word from bytes
VBA