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 vote307 views1 answer
Vbnet check if string is only letters
VBA
4 votes261 views1 answer
Excel formula for last non-empty cell in a column
VBA
0 vote327 views1 answer
(SecurityProtocolType)3072 vb.net
VBA
0 vote287 views1 answer
Vba like with wildcard
VBA
0 vote283 views1 answer
Replace spaces with underscores vbnet
VBA
0 vote269 views1 answer
Vba pass named range to function
VBA
0 vote301 views1 answer
Rotate image by any angle vb.net
VBA
0 vote290 views1 answer
Excel vba disable keyboard input
VBA
0 vote288 views1 answer
Vba check 32 or 64 bit
VBA
2 votes281 views1 answer
Vba round number
VBA