Returning cursor to previous position

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Efto - 02 Mar 2006 12:29 GMT

Is there a way to return cursor to previous position after running a macro? I
will need to execute the macro but without changing the position of the
cursor.

Reply to this Message

Helmut Weber - 02 Mar 2006 15:29 GMT

Hi Efto,

basically like this:

Remember where the cursor is,
execute your macro, and go back.

Sub test0098()
Dim rTmp As Range
Set rTmp = Selection.Range
' execute code here or in another macro
rTmp.Select
End Sub

Which doesn't work,
if the original range isn't there anymore, of course.

Or if your code is in the same macro,
and does change rTmp.

Signature

Greetings from Bavaria, Germany
Helmut Weber, MVP WordVBA
"red.sys" & chr(64) & "t-online.de"

Reply to this Message

Efto - 09 Mar 2006 12:16 GMT

Hi Helmut,

Thank you for your help!

> Hi Efto,
>
[quoted text clipped - 15 lines]
> Or if your code is in the same macro,
> and does change rTmp.

Reply to this Message