how do I paste links and keep formats

when I copy using the paste links function I lose the format. How do I paste
links and keep the format?

You've got to do it *twice*.

Paste Special - click "Links",
Right click again - Paste Special - click "Formats".
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

"cole" <[email protected]> wrote in message
news:[email protected]...
when I copy using the paste links function I lose the format. How do I
paste
links and keep the format?

Just to add, if you change the "sending" cell's format, the "receiving" cell's
format won't change.

RagDyeR wrote:
>
> You've got to do it *twice*.
>
> Paste Special - click "Links",
> Right click again - Paste Special - click "Formats".
> --
>
> HTH,
>
> RD
> =====================================================
> Please keep all correspondence within the Group, so all may benefit!
> =====================================================
>
> "cole" <[email protected]> wrote in message
> news:[email protected]...
> when I copy using the paste links function I lose the format. How do I
> paste
> links and keep the format?

--

Dave Peterson