CODEWITHSUNDEEP
excelvbaexcel-formula
user10776286
user10776286

Reputation: 39

How do I copy a cell that has an online hyperlink to another cell?

I want to copy a cell that has an online hyperlink to another cell (while keeping the hyperlink intact), but every time I try this it just copies the value without the hyperlink.

=hyperlink does not work because that just hyperlinks to my cell's location; not the online hyperlink.

I tried to copy using vba but I ran into the same problem.

Worksheets("X").Range("AD17") = Worksheets("Y").Range("A2")

Upvotes: 0

Views: 1103

Answers (1)

FunThomas
FunThomas

Reputation: 29586

Using the Range.Copy command will copy the text and the hyperlink:

Worksheets("Y").Range("A2").copy Worksheets("X").Range("AD17")

Upvotes: 1

Related Questions