| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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_ | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| write in a cell and the cell above is temporarly hidden | Excel Worksheet Functions | |||
| 2007 Worksheet, Hidden Columns, .CSV Format Saves Hidden Column Da | Excel Discussion (Misc queries) | |||
| How do I detect hidden worksheets or hidden data on a worksheet? | Excel Discussion (Misc queries) | |||
| I need my Hidden Rows to stay hidden when I print the sheet. | Excel Discussion (Misc queries) | |||
| Saving hidden data with a worksheet (preferably without using a hidden sheet) | Excel Programming | |||
Threaded Mode
