On Feb 25, 9:52*am, Scott Bass wrote:
On Feb 25, 8:20*am, Chip Pearson wrote:

<munch

Hi Chip,

Thanks, much appreciated. *Follow up questions:

1) *Is the ResetLastCell macro best practice? *It does take "a while"
to run (say 60-90 seconds on my machine). *Is there a better approach?

I've found a weirdness with the ResetLastCell macro. I've been
manually executing it on each sheet. As I've done so, and re-saved
the .xls file, I've noticed the filesize bloating. It's gone from 3MB
to 54MB! Resaving it as an .xlsx file (we've got the Excel 2007
converters, I'm using Excel 2003) shrinks it to 314KB, so I'm hoping I
can shrink the size of the file using that approach.

Scott