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

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

"Kevin" wrote:

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

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

kevin

Hi
so you only want to copy the hyperlink information?

--
Regards
Frank Kabel
Frankfurt, Germany

schrieb im Newsbeitrag
ups.com...
Frank
thankyou for your reply
The copied Hyperlink should not reference the old source cell

kevin

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