Hyperlinking help

[greatwhitenorth]

I have a hyperlink in sheet 2 that I would like to be dependent on a hyperlink in sheet 1. So if I change the hyperlink in sheet 1, the hyperlink in sheet 2 would change as well.

When I enter a formula of (='Sheet1'!A1) in my destination cell in sheet 2, it copies the text of the hyperlink, but not the hyperlink itself.

Does anyone have a way around that?

Thanks

Ryan

[AndyLitch]

Adjust the cell references in the code to match your source hyperlink and destination hyperlink.
Then run the sub

Please Login or Register  to view this content.