View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Thief_ Thief_ is offline
external usenet poster
 
Posts: 25
Default VBA- Is the cell hidden?

I've Subtotalled a worksheet which resulted in rows being hidden. I now want
to loop thru column A of the worksheet and "massage" the data in only the
visible rows. How can I do this?

The only way I could think of was:

Columns("A:A").Select
Selection.SpecialCells(xlCellTypeVisible).Select

And then cycle the selection....

--
|
+-- Thief_
|