R Randy Reese Mar 20, 2004 #1 My workbook has become over 5megs, thats seems large to me. Is there any way to see why or where this data might be hiding?
My workbook has become over 5megs, thats seems large to me. Is there any way to see why or where this data might be hiding?
F Frank Kabel Mar 20, 2004 #2 Hi Randy maybe re-setting the used range will help. See the following for details: http://www.contextures.com/xlfaqApp.html#Unused
Hi Randy maybe re-setting the used range will help. See the following for details: http://www.contextures.com/xlfaqApp.html#Unused
R Randy Reese Mar 20, 2004 #3 Thanks Frank, I put the code in a module and ran it. From over 5 megs to 525K. Thanks again.