Areas
 

Hello,
I know that I can select the areas selected by using:

Selection.areas.count

Is there a way to know easily which areas are selected one by one? For
example, if I select columns A, C, and E, the above will be give me
selection.areas.count = 3. Is there a way of knowing the address of the
first area, then the second, etc.

Thanks,

Bill

Areas
 

An area is just a range object, so you can use code like

Dim A As Range
For Each A In Selection.Areas
Debug.Print A.Address
Next A


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Bill" wrote in message
ink.net...
Hello,
I know that I can select the areas selected by using:

Selection.areas.count

Is there a way to know easily which areas are selected one by
one? For example, if I select columns A, C, and E, the above
will be give me selection.areas.count = 3. Is there a way of
knowing the address of the first area, then the second, etc.

Thanks,

Bill