How to automaticly duplicate / copy a Hyperlink WITHOUT cut and pa

  • Thread starter Thread starter Chromis
  • Start date Start date
C

Chromis

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
 
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
Click to expand...

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
 
Sorry, I was wanting to do it without cutting and pasting.. I have been
cutting and pasting several hundred hyperlinks at about 100 or so at a time.
I need the raw data (including URLs on 1 page) I also want to work that raw
data with some caluculations on another sheet. on that other sheet, I would
also like the URLs.. The problem is, depending on sorting and custom
filters, I cannot just Cut and Paste the hundreds of URLS over as they will
not match anymore. So I would like it to be done automaticly, so I dont have
to search and find urls one at a time and cut and paste them over.
 
Sub copyhyperlinks()'if simple
Range("c24:c26").Copy Range("f24:f26")
'or a one liner between sheets
sheets("sheet1").Range("c24:c26").Copy sheets("sheet2").Range("f24:f26")

End Sub
 
Thank you for taking the time to answer my question, however, I am not sure
what to do with your answer.. I have opened Visual Basic for my first time
today, and I think that what you have above, needs to go in there. If not
where on the spreadsheet does this go? thank you.
 
Don,

Thank you very much, it works perfectly. Does exactly what I needed it to do.

Also, Thank you Mr McRitchie for the great website.. I will need to look in
there alot more closely.
 
Back
Top