remembering cursor location in macro

[Scott Au]

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 Ivanov]

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