What Cell am I in?

[BK523]

I would like to write a macro that will move x number of cells to the right
from whatever cell (or range) my cursor is currently in.
Example:
if I highlight a range of A20:E20, i would like the macro to move 2 cells to
the right (in this case to G20) and type "X".
if I highlight a range of A15:E15, I would like the macro to move 2 cells to
the right (in this case to G15).

Thanks (in advance) for your help -- this site is a big help to me.

 

[DStrong]

Try this out:
activecell.offset(o,2).select
activecell.value="x"

Is this what you are looking to do?

 

[BK523]

EXCELLENT! - That is JUST what I wanted to do.

Thanks again.

 

[Don Guillett]

Will this do?
Selection.End(xlToRight).Offset(, 2).value="X" 'Select

 

[Don Guillett]

better

Cells(ActiveCell.Row, Selection(Selection.Count).Column + 2) = "X"