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.
[Solved] VBA Macros
[Solved] VBA Macros
Last edited by Hagar Delest on Fri Nov 24, 2017 9:37 am, edited 1 time in total.
Reason: tagged solved
Reason: tagged solved
Open Office macOS Sierra 10.12.6