is there a way to clear memory?

Hi,
I would suggest you that there may be some issue with your machine or into your code..
There are several ways to reduce the memory depends on your code.......
Can I have a look on your code......

Originally Posted by bagullo

hi ashishmehra2010,
actually I use that already in many of my macros

let's imagine that there is some "bad" macro out there that books a lot of memory and never releases it.
Excel then starts complaining about "out of memory" even when the macro has already finished.

is there some way to free all memory without closing and opening excel?

Hi
I already assuming that you already had this in your code.....it can slow or fast your code only to some extent....."Out of memory" happened when your code is using CPU memory a lot....
I am still saying if you can show your code with workbook.....then only I can look into it....otherwise it would be not possible......

Hey,

See if you have been working with VBA from very long period. Then you know all the ways of reducing memory.........these 2 are main.
The main reason behind the memory is the "Variant", if you declare 100 variables explicitly(string,long,data and so on) and you declare 100 variant then you know what would be the result. Always declare variable type rather then Variant.
Again the best practice is when you have a very long code with lots of variable then split the code and call the next sub and so on (you will never run out of memory)....and when you are finishing a code release the memory.....like
Erase Array()
Set object to nothing
If you still think that VBA has lots of data in memory then try pasting some of the data in worksheet and fetch it and delete it when needed......

Hope that helps.....