Error 1004, clean memory?

[Thomas]

High

I use my VBA-code (load data-files, plot data, export diagramms, unload
data and delete diagramm).
After about 30 datasets an error 1004 appears. If I restart with the
30th dataset first everything works fine. Therefore I guess something
like memory overload is the reason.

Does anybody know the error?
Is there any VBA-command to clean memory?

Thanks

Thomas

 

[paulgu]

Thomas,
You need to look at the line of code in which the error occurs and see what it's trying to do at that point. There will probably be something about the data or the state of the workbook at that point which makes it impossible for the statement to be executed. I suggest you use Watch or the Immediate window to look at these things and hopefully detect the cause of the problem.
You could use Task Manager to see what the memory usage is at that point but I'd be surprised if it was a memory problem.
HTH,
Paul