View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Ozgur Pars[_2_] Ozgur Pars[_2_] is offline
external usenet poster
 
Posts: 70
Default How much memory does VBA code occupy?

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