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?
--
Robert K

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.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"RobertK" wrote in message
...
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?
--
Robert K

Add Debra Dalgleish's reset macro to your code.

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


Gord Dibben MS Excel MVP

On Tue, 22 Sep 2009 09:45:01 -0700, RobertK
wrote:

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?

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.
--
Robert K


"Gord Dibben" wrote:

Add Debra Dalgleish's reset macro to your code.

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


Gord Dibben MS Excel MVP

On Tue, 22 Sep 2009 09:45:01 -0700, RobertK
wrote:

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?

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

On Tue, 22 Sep 2009 15:00:01 -0700, RobertK
wrote:

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.