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 vote216 views1 answer
Vba run command
VBA
1 vote218 views1 answer
Excel vba first and last row and column in range
VBA
0 vote217 views1 answer
Vbs send keys
VBA
0 vote229 views1 answer
Convert unix to date vba
VBA
0 vote219 views2 answers
Excel vba close without saving
VBA
0 vote216 views1 answer
System.InvalidOperationException: 'Row associated with the currency manager's position cannot be made invisible.
VBA
0 vote202 views1 answer
Remove frist letter from string vbnet
VBA
0 vote218 views1 answer
Vba shape transparent
VBA
5 votes229 views1 answer
Excel vba highlight cells using the hex color value within the cells
VBA
0 vote226 views1 answer
Vb.net visible property dgv collumn not working
VBA