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 vote139 views1 answer
Reference to a non-shared member requires an object reference
VBA
1 vote137 views1 answer
Excel vba Populating a combobox on a userform from a range of cells
VBA
1 vote143 views1 answer
Set font for ms chart vb.net
VBA
0 vote177 views1 answer
Vbnet add axis labels to chart
VBA
0 vote137 views1 answer
Hello world vb.net
VBA
0 vote140 views1 answer
How to carry text to the next line in a label in vb.net
VBA
0 vote162 views1 answer
Vba random number
VBA
0 vote144 views4 answers
How to continue formula in below line in vba code
VBA
3 votes152 views1 answer
Vba double quote
VBA
0 vote132 views1 answer
Replace spaces with underscores vbnet
VBA