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