Excel macro !!  
Author Message
Bharathi





PostPosted: Fri Apr 30 08:50:52 CDT 2004 Top

Excel Programming >> 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.

Excel8  
 
 
Tom





PostPosted: Fri Apr 30 08:50:52 CDT 2004 Top

Excel Programming >> Excel macro !! Edit=>PasteSpecial

Click the Paste Link button.



--
Regards,
Tom Ogilvy



> 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.
>
>