View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BIG D BIG D is offline
external usenet poster
 
Posts: 14
Default How to automaticly duplicate / copy a Hyperlink WITHOUT cut andpa

On Dec 1, 3:12 pm, Chromis wrote:
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


Select cell B2 by holding the left button until the hand turns to a
cross then copy the cell and paste it anywhere you wish. You should
have a copy of the original link.

regards

BigD