remembering cursor location in macro

I have created a macro which runs from Document 1 and creates Document 2
where it does some search and replace information which then needs to be
copied back into Document 1.

The problem is that it pastes the information at the beginning of the
document and I need it to paste the information where the cursor was when the
macro was initially run.

Does anyone know how I can achieve this?

Thank you,

Scott Au

Alex
Thu Dec 09 00:05:49 CST 2004

Dim r As Range
Set r = Selection.Range
'...
r.Paste



--
Please reply to NG only. This email is not monitored.
Alex.


"Scott Au" <Scott Au@discussions.microsoft.com> wrote in message
news:C876873D-0D42-4817-807A-966E4B66ABAC@microsoft.com...
>I have created a macro which runs from Document 1 and creates Document 2
> where it does some search and replace information which then needs to be
> copied back into Document 1.
>
> The problem is that it pastes the information at the beginning of the
> document and I need it to paste the information where the cursor was when
> the
> macro was initially run.
>
> Does anyone know how I can achieve this?
>
> Thank you,
>
> Scott Au