macros and file size

[CMD]

Hi. I have an excel file to which I have added several macros. It seems
like this has increased the file size pretty significantly. (~7 MB.....it was
around 1.5 MB). I have since deleted the macros but the file size hasn't
dropped back down. I'm a little stuck here. Any thoughts/suggestions?
Thanks in advance.

Chris

 

[Gord Dibben]

Probably not the macros themselves, but the action they took.

Sounds like your worksheets' used range is larger than what you think it is.

See Debra's site for re-setting the used range of a sheet or sheets.

http://www.contextures.on.ca/xlfaqApp.html#Unused


Gord Dibben MS Excel MVP

 

[CMD]

Worked perfectly!!! Thanks so much!!

Chris

Probably not the macros themselves, but the action they took.

Sounds like your worksheets' used range is larger than what you think it is.

See Debra's site for re-setting the used range of a sheet or sheets.

http://www.contextures.on.ca/xlfaqApp.html#Unused


Gord Dibben MS Excel MVP

 

[Gord Dibben]

Good to hear.

Gord

Worked perfectly!!! Thanks so much!!

Chris