How can I determine what is taking up so much memory in my excel workbook?
F Frank Kabel Dec 14, 2004 #2 Hi try the following: http://www.contextures.com/xlfaqApp.html#Unused and see if this helps
C Chip Pearson Dec 15, 2004 #3 Try code like the following: MsgBox FileLen(ThisWorkbook.FullName) This requires that the files be saved to disk at least once. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
Try code like the following: MsgBox FileLen(ThisWorkbook.FullName) This requires that the files be saved to disk at least once. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
