Tom Ogilvy wrote:

Just for clarification, clearcontents won't delete formats, but doing that
won't reduce the size of your file based on what you (the OP) have stated so
far. I think your whole statement about maintaining formats was probably a
mistatement anyway, but only you know what you meant.

I agree with Tom's last statement. I wasn't sure why the formatting would need to be
saved. I used ClearContents to remove data, but not formats.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______