hyperlinks

K

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
 
K

kevcar40

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

kevin
 
K

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
 
Top