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 vote233 views1 answer
Putting marquee in vb.net
VBA
0 vote185 views1 answer
How to make a if statement with vbs
VBA
0 vote251 views1 answer
Power query M substract minimum value of column -dax
VBA
0 vote265 views2 answers
VB
VBA
0 vote255 views1 answer
Excel vba protect scenarios
VBA
3 votes232 views1 answer
Vba request json
VBA
-1 vote247 views1 answer
Vba code to add new column in table
VBA
0 vote256 views1 answer
Vba add spaces
VBA
0 vote268 views1 answer
Vbnet check if string is only letters
VBA
1 vote255 views2 answers
Get all column names from excel vba
VBA