Hi

If you are creating the macro by switching on the Macro recorder and
carrying out the steps, then you need to switch on Relative Referencing
at the start.

ToolsMacroRecord new MacroOK at this point the floating toolbar with
the Stop recording icon should appear.
Next to it is an icon in the form of a Grid. Clicking this is a Toggle
between Absolute Referencing (which is what you are describing) and
Relative Referencing (that you require).

Press this toggle before starting your steps.

Be sure to use the Stop icon at the end, rather than the "x" to close,
otherwise the floating toolbar does not appear next time. If that does
happen, after you start recording the next macro, right click on a blank
area of the toolbars, and from the Toolbar dropdown, click the Stop
Recording bar and it will re-appear.

--
Regards

Roger Govier


"R. H. Rosenberg" wrote in message
...
I've used 123 for over 20 years - simple, easy to learn and use, but
my XP OS doesn't handle it well, so I'm trying to move to Excel. But
in Excel I can't even write a simple macro such as: Copy from a cell,
move down one space, Paste. It will do this once, but then not
continue. If I run it from another cell - just restarts from the
original cell.
Without further comment, I learned this macro in 2 minutes on 123.
I've been working with Excel for a week now, and I'd appreciate some
help. To recap, I simply want to be able to choose a cell having
data, run a Copy macro and have it paste to the cell below- why is
this so damn hard? .

Thanks for any help.

RHR