Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filtered list question
If I have a filtered list, can I determine which columns are shown and
which are hidden after the filter is applied? I tried using the following code but it does not detect filters rows, it only detects if I manually hide the row. Thanks - mike Function Isvis(row, column) Application.Volatile Worksheets("Connector").Activate ActiveCell.Offset(row, column).Activate ActiveCell.Offset(row, column).Select If ActiveCell.EntireRow.Hidden = True Then Isvis = 0 'row is hidden Else Isvis = 1 'row is not hidden End If End Function |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A list of what is being filtered on? | Excel Discussion (Misc queries) | |||
Filtered Cell Question | Excel Worksheet Functions | |||
Top 25 in a filtered list | Excel Programming | |||
filtered list question | Excel Discussion (Misc queries) | |||
Sorting a Filtered List | Excel Programming |