| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Row Expansion | Excel Worksheet Functions | |||
| How to auto activate macro when file opened | Excel Worksheet Functions | |||
| Help with macro looping and color query function | Excel Discussion (Misc queries) | |||
| Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
| Subscript & Superscript | Excel Discussion (Misc queries) | |||
Linear Mode
