Tom,

I agree, except that I'm not doing a straight pasts, trather I'm having to
do two paste specials, one for values and one for formats, so it's not that
easy.

Thanks for your thoughts

Pete



"Tom Ogilvy" wrote:

In code and manually, it is best to do the copy and paste as one set of
actions with no intermediate actions.

As to why, I would imagine that Excel errs on the side of caution in
assuming that almost any action outside of pasting could change the
environment of what was copied.

--
Regards,
Tom Ogilvy

"Peter Rooney" wrote in message
...
Good afternoon,

Can anyone tell me why when, if I copy something to the Clipboard, then
try
to change a setting to something like scroll bars, worksheet tabs, formula
bar etc, the clipboard empties?

This works in "normal" Excel, as well as VBA - do a copy, then select
"Tools" and "Options" from the menu, and the carousel line around the
selection disappears!

It's causing me MAJOR problems - I'm using 2003 on XP

Thanks

Pete