How much memory does VBA code occupy?

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

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" <OzgurPars@discussions.microsoft.com> wrote in message
news:18B28EBF-E9C3-46F9-886F-2C8D50C3C2FD@microsoft.com...
> 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

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" <OzgurPars@discussions.microsoft.com> wrote in message
> news:18B28EBF-E9C3-46F9-886F-2C8D50C3C2FD@microsoft.com...
> > 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
>
>
>

Hi Oz,

> Thank you a lot for your help!

I should have added in my reply that an essential site for matters related
to memory is Charles Williams DecisionModels site:

http://www.decisionmodels.com/optspeedd.htm


---
Regards,
Norman

Hi Oz,

You may also wish to 'spring clean' your code using Rob Bovey's
indispensable Code Cleaner addin, which may be downloaded, free of charge
at:

http://www.appspro.com/Utilities/Utilities.htm


---
Regards,
Norman



"Ozgur Pars" <OzgurPars@discussions.microsoft.com> wrote in message
news:18B28EBF-E9C3-46F9-886F-2C8D50C3C2FD@microsoft.com...
> 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