don't copy to the clip board until the next action is to paste. Make your
changes before copying.



--
Regards,
Tom Ogilvy

"Peter Rooney" wrote in message
...
Good morning, all,

I notice that if I copy something to the clipboard, then alter any of the
application or window display settings, the contents of the Clipboard are
lost.

This happens in "Normal" Excel too, as well as in VBA - can anyone suggest
a
way of somehow preserving the contents of the clipboard?
I'm using Excel 2003.

Thanks in advance

Pete