Hi Norman,
I checked out the site and got the reset used range code... it reduced the
empty workbook to 230 kbyte and the one with data to 1.87 MB...
Thank you a lot for your help!
Ozgur
"Norman Jones" wrote:
Hi Oz,
After deleting the data did you reset the used range?
See Debra Dalgleish's suggestions at:
http://www.contextures.com/xlfaqApp.html#Unused
As an independent check, try copying the code module(s) into a new workbook,
save the workbook and look at its size,
---
Regards,
Norman
"Ozgur Pars" wrote in message
...
Hi,
I know its probably a dumb question but I have a file in which I copy data
from another workbook through named ranges. Its a fairly big amount of
data
so when copied the file is aroun 2.5 MB but when I delete all the data the
workbook is still 1.1 MB... does simple code take that much of space.
Thanks,
Oz