dim myStartRng as range
set mystartrng = selection

'do your work

application.goto mystartrng



Trintrin wrote:

can anyone tell me how to edit a macro so that it takes you back to
where you were before you hot keyed the macro rather than the last
active point in the macro.

--
Trintrin
------------------------------------------------------------------------
Trintrin's Profile: http://www.excelforum.com/member.php...o&userid=32681
View this thread: http://www.excelforum.com/showthread...hreadid=527753

--

Dave Peterson