Error 1004, clean memory?

[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

 

[mudraker]

There are lots of ways to have Excel use up available memory

Poorly coded macros is 1 method

Do a internet search on Excel memory Leaskage you will find lots o
articles but nothing that will give you an simple answer to what i
causing the problem or how to solve it

A good starting point would be to post a copy of your book or at leas
the code & desribe what it is doin

--
mudrake

If my reply has assisted or failed to assist you I welcome you
Feedback.

www.thecodecage.co