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 votes202 views1 answer
Vba make long from two words
VBA
0 vote270 views1 answer
Amd64 vs arm64 linux
VBA
0 vote180 views1 answer
Excel vba linter
VBA
0 vote214 views1 answer
Vba cell all borders
VBA
1 vote196 views1 answer
Excel vba Populating a combobox on a userform from a range of cells
VBA
0 vote189 views2 answers
Excel vba close without saving
VBA
0 vote213 views1 answer
Selecttoken em vbnet e json
VBA
1 vote202 views1 answer
Vbs run
VBA
0 vote192 views1 answer
Vb.net change cursor to wait
VBA
0 vote213 views1 answer
Search for text in every worksheet excel visual basic
VBA