How much memory does VBA code occupy?

[Guest]

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

 

[Norman Jones]

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,

 

[Norman Jones]

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

 

[Guest]

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]

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

 

[raypayette]

Deleting data still retains information such as formatting. It is bette
to use Edit, Clear, All

 

[Norman Jones]

Hi Ray,

Deleting data still retains information such as formatting. It is better
to use Edit, Clear, All.

Using Edit , Clear All may not reset the used range.

In this connection, you will note that Oz reporrted favourable results after
using techniques suggested by Debra Dalgleish to reset the used range.