Say I have a hyperlink in Cell B2 I want to make a copy of that cell in B10
How would I do this..

If I just use the formula of =B2 in cell B10 it just shows the name of the
and NOT creating something that will allow me to click on it.

(I am actually doing this across pages in same workbook, but the concept
should be the same.

Any help would be appreciated