Error 1004, clean memory?

  • Thread starter Thread starter Thomas
  • Start date Start date
T

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error 1004, clean memory? 1
Unexpected internal error or not enough memory 1
Error 1004 after copying 84th worksheet to a new workbook... 2
Memory jam after too many worksheet copy steps? 3
Application.Quit Run-Time Error 1004 6
VBA Excel - changing series source. 3
Excel 97 VBA on Win98 Out of Memory Error 2
Project Still Open When Workbook is Closed 2

Back
Top