View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Cell access within Selection.Areas

Dim a As Range
Dim cell As Range

For Each a In Selection.Areas
For Each cell In a
Debug.Print cell.Address
Next 'cell
Next 'a

You should add error code in case Selection is not a range.

NickHK

"maxcad" wrote in message
...
I am trying to sequentially access cells with multple selection areas. I
know that Selection.Areas(1) is supposed to be the first group of selected
cells, but how do I access them? Selection.Areas(1).Cells(1,1) doesn't

work.

Any insights would be appreciated.