Range.Areas question

[Dave Sell]

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

[BrianB]

!. 'Areas' relate to *selected* cells where there are several *unconnected* ranges, such as achieved by holding down the Ctrl key prior to selection using the mouse. If there is only one selected range, there is only one Area.

2. If you want to break a single range into several parts I suggest you use named ranges. When using VBA there is rarely a need to use Select, and then only when it is necessary for the user to see something on scren.

[Dave Sell]

OK thanks for the advice, I'll try that.

Dave