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" wrote in message
...
when I copy using the paste links function I lose the format. How do I
paste
links and keep the format?