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

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 of
articles but nothing that will give you an simple answer to what is
causing the problem or how to solve it

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


--
mudraker

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

www.thecodecage.com
------------------------------------------------------------------------
mudraker's Profile: http://www.thecodecage.com/forumz/member.php?userid=18
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=59564