AutoFilter and Hidden Rows
 

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

AutoFilter and Hidden Rows
 

Try this...

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



-----Original Message-----
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


.