Page 1 of 1

[Solved] VBA Macros

Posted: Sat Nov 04, 2017 9:49 pm
by alanbeban
In VBA, how do I refer to multi-area ranges? For example, with

Set rng1=ThisWorkbook.Worksheets(1).Range("A1:B2")
Set rng2=ThisWorkbook.Worksheets(1).Range("C3:D4")
Set rng3=ThisWorkbook.Worksheets(1).Range(" ? ")

so that rng3 is the multi-area range comprised of rng1 and rng2?

Thanks.

Re: VBA Macros

Posted: Sun Nov 05, 2017 8:54 pm
by alanbeban
Never mind.

Set rng3 = Union(rng1,rng2)