AutoFilter and Hidden Rows

  • Thread starter Thread starter Greg Bloom
  • Start date Start date
G

Greg Bloom

When you set the autofilter on, how can you tell what rows have been hidden.
I am starting at the top of my workshett and using: ActiveCell.Offset(1,
0).Select. This returns rows that are hidden, and I want to ignore these
rows?

thanks
Greg
 
Try this...

Public Sub FindVisible1()
With ActiveSheet.AutoFilter.Range
.Offset(1, 0) _
.Resize(.Rows.Count - 1, .Columns.Count).Select
End With
End Sub
 
Back
Top