View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mike mike is offline
external usenet poster
 
Posts: 10
Default 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