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?