View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
steven steven is offline
external usenet poster
 
Posts: 389
Default ActiveCell.Offset on filtered data

I want to do ActiveCell.Offset(1, 0).Range("A1:A1").Select on a column that
is filtered. My problem is that I want it to go to the next visible row.
When I do this currently if the row is not visible it will still offset to
the hidden row. Is there a way I can make it automatically offset to the
next visible row?

Thank you for your help.

Steven