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 vote121 views1 answer
Vbs exec hidden
VBA
4 votes118 views1 answer
Excel formula for last non-empty cell in a column
VBA
0 vote150 views1 answer
Excel vba protect shapes
VBA
0 vote115 views1 answer
How to format a textbox as date vb net
VBA
0 vote134 views1 answer
Vba listbox remove all items
VBA
0 vote128 views1 answer
How to convert weeks to days into textbox with VB site:stackoverflow.com
VBA
1 vote123 views1 answer
Excel vba Populating a combobox on a userform from a range of cells
VBA
0 vote139 views1 answer
VBA Sort RossetaCode
VBA
5 votes140 views1 answer
Xlvba double quotes in string literal
VBA
0 vote116 views1 answer
Vbnet chart make 0 gridline line different color
VBA