Menu
  1. Accueil
  2. Tech Forum
  3. Office Software

How to Move the ActiveCell to the next row [Closed]

Report
Posts
2
Registration date
Monday July 6, 2009
Status
Member
Last seen
July 7, 2009
 -
venkat1926
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
 -
Hello,
Move the ActiveCell to the next row is simple:
ActiveCell.Offset(1,0).Select
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
name gender
Jeni Female
Jhon Male
Alex Male
Peter Male
Flex Male
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.

Thanks.
Shylendra
See more
Related:

1 reply

Answer 1 / 1
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
 790
try this code statement 

ActiveCell.Cut
ActiveCell.End(xlDown).Select
ActiveSheet.Paste
Application.CutCopyMode = False
Thank you
5
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 4254 users have said thank you to us this month

Ask a question