View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RobertK RobertK is offline
external usenet poster
 
Posts: 28
Default Size of file grows

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