Running the code probably clears the clipboard, so there is nothing to paste
when the code runs.

--
Regards,
Tom Ogilvy

"Tim" wrote in message
...
Hello All,

I created a macro by recording PasteSpecialValues. It
works fine when I use the shortcut key or a custome
button, but I get an error (Method of Range Class failed)
when I try to run the macro from the "Run" button in the
Vb toolbar. Any ideas.

Thanks in advance