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

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" <bill@bpiconsulting.com> wrote in message
news:bv6Kf.1207$5M6.1204@newsread2.news.atl.earthlink.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
>