Hi,

I think you need to supply more information. If you run
out of memory it basically means you need to keep less
data in memory at any given time, which means you have to
persist state elsewhere (such as a file). That of course
affects the basic design of the solution, so it may lead
to a completely different implementation in the end.

However, unless you are dealing with very large volumes of
data, it seems likely that you are not using memory
efficiently. In particular, if you use user-defined types,
be aware that they are always marshalled by value; i.e.
whenever you pass the type as a parameter to a function,
the data structure is copied - you cannot pass it by
reference. Such a design can therefore

In short, you will have much better chances of actually
getting help if you provide more information; preferrably
with the offending code.

Good luck, happy coding!

Dag

-----Original Message-----
Does anyone know how to solve the 'out of memory' error
in excel vba?


.