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

3 votes200 views1 answer
Excel vba get the workbook full filename with path
VBA
0 vote187 views1 answer
Check if program is running vbnet
VBA
6 votes189 views1 answer
Excel vba get the path of current workbook
VBA
0 vote181 views2 answers
Vb.net include quotes in string
VBA
0 vote181 views1 answer
Windows Presentation Foundation dark title bar
VBA
0 vote170 views1 answer
Hello world vb.net
VBA
0 vote202 views1 answer
Build an index all files of a FTP site
VBA
1 vote177 views1 answer
Excel vba Refreshing all pivot tables in workbook
VBA
0 vote237 views1 answer
Excel vba delete columns in range
VBA
3 votes227 views2 answers
Excel "vba" match last value
VBA