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
.
|