try something like this
(at ther beginning of the macro after public sub -----())

dim cc as range
set cc=activecell
then other code staements

(at the end of the macro before end sub
type

cc.select

try this and see whether you get what you want.

"sony654" wrote in message
...
I am writing a macro that will always start in a different cell, but needs
to
reference back to the starting cell each time it is run. For example, if
the
cursor is in cell d3 when the macro is run, the macro must return to d3
when
finished. The next time the macro is run, it will start in e3, and return
to
e3 when finished. I use the macro recorder to write my macros, how do I
write it to have the routine always end in the starting cell?


--
Sony Luvy