Paste

[Tim]

Hello All,

I created a macro by recording Paste>Special>Values. 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

 

[Tom Ogilvy]

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