Select visible cells using vba
Range("A1").Select
do
ActiveCell.offset(1,0).Select
Loop While ActiveCell.EntireRow.Hidden = True
Did you want to select the second visible cell below the current selection
rather than the next visible cell?
--
Regards,
Tom Ogilvy
"Tony" wrote in message
...
Hi there,
Using vba code, I want to select a cell that has been filtered?
ie.
Range("A1").select
Activecell.offset(2,0).select - this selects Range("A3") but is not
visible.
I want it to consider visible cells only.
Any ideas?
|