Paste

T

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
 
T

Tom Ogilvy

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