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_
|
|