Macro Enabled Excel - Run Time Error 1004

Hi All,


I am using a macro enabled excel file for the purpose of calculating certain accruals of income and depreciation on contracts. However I experienced a run time error 1004 -
Application – defined or object –defined error


This error has never occurred to the earlier users of the same macro. I do not understand if the source file from which the data is getting copied into the macro file is corrupt or not.

Find below the VB program code , I have highlighted the line where the error seems to occur when I clicked on the debug option. Would appreciate if anyone would be able to help me resolve it and also explain me in laymen terms what the issue is. I am from finance background with no knowledge about VB

Thanks alot for the support


ERROR is occuring with the below line

Range("hdrCount").Offset(1).Resize(rrData).PasteSpecial xlPasteFormulas

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

attach your file

The only obvious things to check are 1) if the named range hdrCount exists and 2) what value does rrData have. Is the sheet you are copying to protected?

And, as Patel45 has suggested, maybe a good idea to upload a sample workbook that exhibits the problem.


Regards, TMS

Oh, and the other point is, it's hard to diagnose a run time error if you don't have the workbook and data that is producing it


Regards, TMS