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


.