How do you move the selection one cell to the right in a macro
 

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

How do you move the selection one cell to the right in a macro
 

See the Offset command. E.g.,

ActiveCell.Offset(0, 1).Select



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

How do you move the selection one cell to the right in a macro
 

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

How do you move the selection one cell to the right in a macro
 

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