View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Thomas[_23_] Thomas[_23_] is offline
external usenet poster
 
Posts: 2
Default Error 1004, clean memory?

High,

I use a macro which load dataset, calculate something, create a
diagramm, export it and unload the data.
It works fine but after about 30 times an Error 1004 appers. (The
current dataset is not the problem, if I restart with the 30th dataset
first it works without error.)
I guess there is a problem like memory overflow or something like this.

Does anybody know something about this error?
Is there a possibility to clean the memory by VBA-code?

Thanks a lot.

Thomas