I am creating a paste link from worksheet A to worksheet B. The cell on
worksheet A is formatted with one word in regular arial font and the second
word in italics. Is there a way to keep this formatting in a paste link at
the destination (worksheet B)? So far, I have tried the paste link and
immediately followed with the paste special format, but this has had no
effect. Likewise, I am attempting the same exercise with VLOOKUP.

Would anyone have a solution?

Thanks!