Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() If YourCell.EntireRow.Hidden = True Then ' the cell's visible ' .... Else ' the cell's hidden ' ..... End If HTH, Jouni "Abelardo Vacca" wrote in message ... Hello, I'm doing an Excel Macro and I need to know if there is a way of see the difference between filtered (not visible) cells and the nonfiltered (visible) cells within a Range. I'm scanning the Range to do a task on each cell, but i need to ignore the non visible cells. Thanks a lot |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Average For Filtered Cells | Excel Worksheet Functions | |||
Copying four filtered cells | Excel Discussion (Misc queries) | |||
Numbering cells that have been filtered | Excel Worksheet Functions | |||
filtered cells | Excel Discussion (Misc queries) | |||
Pasting onto filtered cells | Excel Worksheet Functions |