I think you have to paste to a temporary holding sheet/area, and copy from
there at the end of your macro. This is only necessary if
Application.CutCopyMode is not equal to False of course.

--
Jim
"Kris" wrote in message
oups.com...
| Hi All,
|
| I have a macro that, because of the actions that it carries out, ends
| up destroying the contents of the clipboard. Can anyone tell me how I
| can backup and restore the contents of the clipboard before the body of
| my macro executes?
|
| Thanks,
| Kris
|