Excel VBA Runtime 1004 Error

Hello everyone,

Running into issues with a 1004 runtime error. I've used this code for several months without issue. This past month my customer added a few new columns to their report. I updated the code to delete them accordingly. I've tried adding these columns to a previous report and it runs fine. Something specific with the file?

Errors out on the following line: Sheets(1).Range("A1:O" & DestRow).Value = DestArray.

Any help would be greatly appreciated.

Please Login or Register  to view this content.

Disregard. Was able to figure it out. One of the field's values started with an "=" which must have thrown off the code. Once I removed it, it ran successfully.