Thread: File size...
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Darin Kramer Darin Kramer is offline
external usenet poster
 
Posts: 397
Default File size...

Howdie...

I have a small workbook (3sheets) that uses advanced filter to copy and
paste data from sheet A to Sheet C.

The total list of data in sheet A is just 10 lines, and my filter
selects and copies two lines of this to a sheet c, but yet my file size
is 4 megs.
Sheets A and Sheets C are the big ones (If I delete them file size
drops) but as they contain hardly any data I dont know why...

Any macros or ideas that I can do to solve the problem... are most
welcome...

Regards

D

*** Sent via Developersdex http://www.developersdex.com ***