Excel macro !!
 

Hi all.
I want to write a macro in an excel sheet wherein I want to copy a few
cells
from my source worksheet and paste their link ...not teh HYPERLINK.....to
another worksheet.
Also, the destination worksheet's cell number where this is pasted is not
fixed. How do I accomplish this?
Please help urgently.
Thanks.

Excel macro !!
 

Edit=PasteSpecial

Click the Paste Link button.



--
Regards,
Tom Ogilvy

"SPG" wrote in message
...
Hi all.
I want to write a macro in an excel sheet wherein I want to copy a few
cells
from my source worksheet and paste their link ...not teh HYPERLINK.....to
another worksheet.
Also, the destination worksheet's cell number where this is pasted is not
fixed. How do I accomplish this?
Please help urgently.
Thanks.