Select visible cells using vba
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?
|