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 |
All times are GMT +1. The time now is 01:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com