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 vote340 views1 answer
Excel vba remove formatting from cell
VBA
0 vote328 views1 answer
Vba change named range address
VBA
0 vote346 views1 answer
Vbscript remove spaces from string
VBA
5 votes354 views1 answer
Excel vba tool to help with refactoring code
VBA
0 vote325 views1 answer
Compare dates vb
VBA
0 vote356 views1 answer
COMO GRAVAR U VALOR NO ARQUIVO APPSETINGS EM VB NET
VBA
0 vote330 views1 answer
Vba DisplayGridlines
VBA
6 votes372 views1 answer
Excel vba get the path of current workbook
VBA
0 vote311 views1 answer
Vba string start with
VBA
0 vote330 views1 answer
Vbnet check if sting contians symbols
VBA