Hello
ActiveCell.Offset(0,1).Select

HTH
Cordially
Pascal

"Dennis Cheung" a écrit dans le
message de news: ...
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?
--
Dennis Cheung