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
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.