Move the active cell

[Guest]

Dear Sirs,

Can someone help to write a Macro to move the active cell to my designated
location, not by cell reference. But go to somewhere by direction and
distance.

Example: The active cell is B1, but it is variable. I need the active cell
to go to the next cell in its right hand side, it means C1. Or from C1 to D1,
Or from C3 to C4.

Is it possible? Can someone help?

 

[papou]

Hello
ActiveCell.Offset(0,1).Select

HTH
Cordially
Pascal

 

[Norman Jones]

Hi Dennis,

If your intention is to select the next cell in the
current row programmatically, Papou has suggested
the required code.

If, however, your intention is to select the next cell in
the current row in response to the Enter key, try:

Menu | Tools | Options | Edit |
Move selection after Enter | Right