Thread: Areas
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bill[_30_] Bill[_30_] is offline
external usenet poster
 
Posts: 89
Default 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