Emptying your variables after you used them often works in these cases
Some of them (like workbook or worksheet) can take up a lot of memory

--
Message posted from http://www.ExcelForum.com