G
Guest
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
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