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