Esteemed Forum Participants and Lurkers:
Excel 2003 VBA
I need a process (code) to copy Hyperlinks from a cell on one sheet to a specific related cell on another sheet while preserving the format of the target cell. The Target Cell may have any number of different background and border formats. For test, it can all be on the same sheet from one column to another.
If I copy the source cell and paste it on the destination cell, it overwrites the destination cell format, but that appears to be the only way I can copy the link. There doesn't seem to be any "Paste Special" to paste just the Hyperlink. Paste Special Values doesn't work ... paste special formulas doesn't work ... etc. ad nauseam.
I tried to copy just the format from the TARGET cell and paste it on the Source cell so that I could then copy the identically formatted Source cell back on the Target cell, but when I paste the format, it crashes the Hyperlink, leaving only the link text.
Is there any quick and dirty way to do this without having to save every format property of each target cell and then rewrite them all?