View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BK523 BK523 is offline
external usenet poster
 
Posts: 7
Default What Cell am I in?

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.