Filtered list question

M

mike

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list control value in vba 2
filter function 0
Remove Identical words 0
Perplexing IF statement 4
= CHAR(Row() + 61) 2
Totals rows shouldn't become invisible when filtering 3
Copy filtered data to sheet 2 1
access table results after filtering 1

Top