run time error '1004'

[michaelt23]

I have a macro someone else created and has since left the company, and when I try to run it I get this, any suggestions?

Run-time error '1004':

PasteSpecial method of range class failed


Here is a copy of the code where it is erroring at.

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



IF you need more of the code let me know.

Thanks,
Michael

 

[PolarBear]

Michael,

I've often seen the "1004" error, and it usually means I've misspelled the name of the sheet or range I'm looking for. Check your spelling carefully for extra spaces, etc. that might be causing the problem.

HTH,

Kevin

 

[Norie]

Kevin

The most common error when a name has been misspelled is normally Subscript out of Range.

 

[michaelt23]

Kevin,

This macro creates the file itself, there is no file for it to look for.