When you're recording the macro, you'll see two icons on that "stop recording"
toolbar.

The second one is "relative reference". Click it and see if that does what you
want.

Or maybe you could just examine the existing recorded code and start using
ActiveCell instead of the original's address.

You may want to post back if you have trouble. There might even be ways of not
selecting anything at all.

(Usually the code is easier to follow and runs a little quicker, too.)

hh wrote:

how do i record new macro so that when i run it, it
starts from the selected cell and not revert back to the
cells that i recorded it in?
thanks, desperate!

--

Dave Peterson