Copy an existing hyperlink to another cell

Closed
ShkeT - Jan 14, 2012 at 03:58 AM
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
- Jan 15, 2012 at 09:05 PM
Hello,

Could you please advise how to solve the following problem.


I have in Sheet1, cell A1 a hyperlink to google.com
In Sheet2, cell A1 I copy the info from Sheet1, cell A1 (='Sheet1'!A1). But the hyperlink from Sheet1, cell A1 is not copied to Sheet2, cell A1.

Could you please advise how can I copy automatically the hyperlink?

Thank you in advance.

2 replies

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
805
Jan 15, 2012 at 06:17 AM
this is not knowledge
this is experience

=sheet1!a1
only copies the value (not hyperlink or formula)

copy paste(or pastespecial-all) does copy the hyperlink or formula
0
So there is no way to do it automatically? :(
0
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
805
Jan 15, 2012 at 09:05 PM
what is meant by "automatically" you can have a macro

a trivial example of macro is

Sub test()
Worksheets("sheet1").Range("a1").Copy Worksheets("sheet2").Range("a1")
End Sub


even you have a button in sheet1 and if you click that button the macro is run
0