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

2 votes144 views1 answer
Vba array contains
VBA
0 vote162 views1 answer
.net dark title bar
VBA
0 vote156 views1 answer
Vbnet check if sting contians symbols
VBA
8 votes251 views1 answer
Excel vba determine number of elements in a 1D array
VBA
0 vote150 views1 answer
Enter into cells data grid view
VBA
0 vote154 views1 answer
Add items to combobox vb.net
VBA
0 vote154 views1 answer
Vba sheet visible
VBA
0 vote169 views1 answer
Power query M substract minimum value of column -dax
VBA
1 vote157 views1 answer
Excel vba first and last row and column in range
VBA
1 vote152 views1 answer
Excel vba make cell visible
VBA