Posts2Registration dateMonday July 6, 2009StatusMemberLast seenJuly 7, 2009
Jul 7, 2009 at 09:38 AM
Posts1863Registration dateSunday June 14, 2009StatusContributorLast seenAugust 7, 2021
Jul 12, 2009 at 08:50 PM
Move the ActiveCell to the next row is simple:
Ok. But if AutoFilter is on, that command can lead me to a non shown cell.
How can I do if I only want to iterate across the shown cell?
Example below table in A1 and B1
Once I filter critera as Male from column B Row 2 will not be shown.
Now if I use ActiveCell.Offset(1,0).Select from B1 it will take me to B2 only but I need the cell in B3
I would appreciate very much a help.