Macro troubles
Posted by Joe on January 29, 2002 10:16 PM
I'm trying to record a simple macro that will do a Paste Special > Value. It records fine, but when I play it back, I get the following error message:
"Runtime Error '1004':
PasteSpecial method of Range class failed"
Any ideas?
Posted by Pernicius on January 30, 2002 12:08 AM
Post your code so it can be checked.
(Does the macro do PasteSpecial only? If so, you need to copy something before running the macro.)
