So you could still paste into excel but use PasteSpecial to specify ho (ie
xlvalues?).

"Tom Ogilvy" wrote in message
...
CutCopyMode for sure - but that is usually what someone is doing when they
copy in Excel.

--
Regards,
Tom Ogilvy

"Damien McBain" wrote in message
...
"Tom Ogilvy" wrote in message
...
It would be difficult. If performing an action causes an adverse
situation,
then the work around is to avoid the action. In this case, I think you
might have to give something up. You are correct that many actions
performed by macros cause the clipboard to be cleared.

Does it clear the windows clipboard or just deactivate cutcopymode in
excel?