Macro for copy and paste as link

Hi

I have this macro and want to change this to when it paste it paste special as link (link to another sheet ) not value,
Thanks
RR

Please Login or Register  to view this content.

Hello. I removed the paste coding you had and added another method so try this.

Please Login or Register  to view this content.

Thanks for your time,
But I want link as (C:\Documents and Settings\All Users) So when ever any value change on other sheet then my this sheet get update too. I do not want hyperlink.

Sorry, Just use the code below:

Please Login or Register  to view this content.