macro button

[Tim]

Hello All,

I was just showing someone how to record a macro and
experienced a strange problem. We
recorded "paste_special_values" using a shortcut key and
a macro button. The macro runs fine if you use the
shortcut key or the macro button, but when i try to run
the macro using the "Run" button a get an
error "PasteSpecial method of Range class failed".

Selection.PasteSpecial Paste:=xlValues,Operation:=xlNone,
SkipBlanks:= _
False, Transpose:=False

Any ideas?

 

[Tom Ogilvy]

When you run the macro using run, it clears the clipboard, so there is
nothing in the clipboard to paste.

 

[Tim]

Is there a reason for this? I can work around it without
a problem.....just curious.

Thanks

 

[Tom Ogilvy]

If you want reasons, you will have to ask microsoft.