[Solved] VBA Macros
Posted: Sat Nov 04, 2017 9:49 pm
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.
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.