Hi All,

I'm creating quite a large file with a number of macros and a lot of arrays. After running about the 5th sub I start to get an out of memory message. I just wondered if there way a way at the end of each sub to make sure that everything is cleared from excels memory to free up space.

Hoping i've understood how this works!

Thanks In advance