Hi,

If I have a range from an Excel worksheet, how do I make more Areas than it starts with?

If I create a range from A1:A6, and try to access the Range's Areas collection, Areas(1) seems to contain only "A1". How do I make or define more Areas, like:

Set Range.Areas(2) = "A2:A4"

or something like that. Do I have to programatically select a new range to create a new area?

Please shed some light on this confusing topic!

Dave