Copy / Paste Hyperlink, but not Formats

  • Thread starter Gary''s Student
  • Start date
G

Gary''s Student

Is there an easy way to copy a hyperlink from one cell and paste it to
another without pasting the format ??

I don't want to change the destination cell's background color, alignment,
borders, etc.

If I paste/special/value, the destination only contains the "friendly name",
not a hyperlink.

I can do this with VBA, but I shouldn't need a macro for something this
simple.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top