Clear Cache For Excel 2007 using VBA

[PrashanthNair]

Hi guys..

My name is Prashanth from Malaysia. I would like to know if it is possible to clear cache in excel 2007 using VBA. With the higher number of repetition of a calculation such as 1000 times, vba codes goes "Out of Memory". How do we clear this cache to resume the calculation?

 

[Andrew Poulsom]

Have you read Excel's specifications? The number of sheets in a workbook is limited by available memory. Maybe you don't have enough memory to add that may sheets. There isn't a cache to be emptied and I don't know a workaround.

 

[PrashanthNair]

OK..hmm..thanks for your advice..i don't face the same problem with lower number of runs..i also think the memory might be the problem..thanks a lot... Is there any possibility to delete the memory so that i can maintain the speed of each run of the macro?..i realize the macro gets slower with higher number of run..is this due to the memory too??..