Size of file grows

[RobertK]

I have a workbook where I transfer data from several pages to what I call the
Sorting Sheet, perform various sorts and than transfer the data to other
woeksheets. Before saving the file the Sorting Sheet is cleared. The
process runs on a macro. However, everytime I run the macro the file size
increases about .02MB, not a lot but after many operations the size gets to
be a problem. Deleting the worksheet and installing a new one brings the
file size down to the original but I've been unable to add that process into
my macro. Any suggestions?

 

[Don Guillett]

As always, post YOUR macro for comments.
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You send a clear explanation of what you want
3. You send before/after examples and expected results.

 

[Gord Dibben]

Add Debra Dalgleish's reset macro to your code.

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


Gord Dibben MS Excel MVP

 

[RobertK]

Thanks, but I'm not as Excel lirterate as I'd like to be and I can't figure
out how to fit the macro to my spreadsheet.

 

[Gord Dibben]

You could just add a call to Debra's macro at the end of yours.

Sub yourmacro()

does the things you do

Call DebraMacro
End Sub

Once you have posted your current macro code we can see where to fit it in
if needed.

Your current macro may just need changing to stop the addition of the excess
rows and/or columns being filled.


Gord