Go back to where you were before the Macro
 

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

Go back to where you were before the Macro
 

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

Go back to where you were before the Macro
 

awesome!!!


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