PDA

View Full Version : Activecell.movenext?



prabhafriend
01-05-2010, 01:40 AM
Is there any simple method to select the next cell of the active cell like activecell.movenext

Bob Phillips
01-05-2010, 01:56 AM
What is next, right or down?

You can do it by setting it in Tools>Options>Edit>Move Selection After Enter.

mbarron
01-05-2010, 07:20 AM
If you require the movement in code.

This will select the cell below ActiveCell
ActiveCell.Offset(1).Select
This will select the cell one column to the right of the ActiveCell
ActiveCell.Offset(,1).Select

prabhafriend
01-05-2010, 07:23 AM
Thank you Baron