michaelt23
MIS
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
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