ActiveCell.Offset(Row, Column).Activate
EXAMPLES:
to move the active cell to the right one:
Activecell.Offset(0,1).Activate

to move it down one:
Activecell.Offset(1,0).Activate

to move it left 2 and up 3:
Activecell.Offset(-2,-3).Activate

fder Wrote:
How do you move the selected cell in any direction from any arbitrary
position? I'm just using the VB editor.


--
Ikaabod
------------------------------------------------------------------------
Ikaabod's Profile: http://www.excelforum.com/member.php...o&userid=33371
View this thread: http://www.excelforum.com/showthread...hreadid=541205