hyperlinks

[Kevin]

Hi

I have created a hyperlink on a worksheet using the formula

=HYPERLINK(BB1,BR1)

this creates the hyperlink no problem

what i want to do is copy the hyperlink from one worksheet to another worksheet

when i try this i only manage to get the text value to paste

can anyone please tell me how to copy and paste a hyperlink ?


thanks in advance


kevin

 

[Guest]

Hi
should the copied Hyperlink still reference the old source cells?

 

[kevcar40]

Frank
thankyou for your reply
The copied Hyperlink should not reference the old source cell

kevin

 

[Frank Kabel]

Hi
so you only want to copy the hyperlink information?

 

[kevcar40]

Frank
I want to copy the actual hyperlink from one workshet to another
and have the hyperlink work on the second worksheet, targeting the
hyperlink address not the original cell it was copied from.
thanks kevin