and no I am not pasting into part of the copied range
"Tom Ogilvy" wrote in message
...
Are you pasting into part of the copied range or otherwise altering it.
This will clear the clipboard. If I don't alter the source range, I can
paste special multiple times.

Regards,
Tom Ogilvy

"billQ" wrote in message
...
Hello,
I am pasting data to cells using
Selection.PasteSpecial
Using this I can only paste to another cell once. Using the clipboard
viewer, I noticed that after the first paste the clipboard is cleared,
preventing additional pastes.
Any help will be appreciated.
thanks
bill q