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 vote368 views1 answer
Programmatically copy data from one workshet to another excel
VBA
0 vote327 views2 answers
Delete all controls from list of control vb.net
VBA
0 vote295 views1 answer
Vb.net round to 2 decimal places
VBA
0 vote332 views1 answer
Vbs exec hidden
VBA
6 votes359 views1 answer
Excel vba get the path of current workbook
VBA
0 vote301 views1 answer
Returns an array from function vba
VBA
0 vote346 views1 answer
Create links in msgbox in vb
VBA
0 vote339 views1 answer
Find if year is leap year vb
VBA
0 vote309 views2 answers
Excel vba prevent save
VBA
2 votes306 views1 answer
Date format for ms chart vb.net
VBA