Error 1004, clean memory?

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

Thomas

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
 
Thomas,
I'd suggest you look at the statement in which the error occurs. You may have a numeric variable such as a total that is overflowing (i.e. being set to a value that is larger than the maximum it can hold). If that's the case change the type pf the variable so that it can hold larger numbers.
Whatever the problem, inspecting the code in which it occurs will give you a better idea of what the problem is.
HTH,
Paul
 
Back
Top