David,

Someone came by and helped me to fix the code. It was broken incorrectly on
different lines. It worked!

Thanks so much. Hopefully this will get the spreadsheet running for awhile.
I'm a temporary worker at the moment.

"Nanette" wrote:

Hi David,

I took your suggestion and put in the macro myself which I copied from your
post at
http://groups.google.com/groups?thre...%40tkmsftngp02.
Unfortunately, it isn't working. I'm getting syntax errors and am not sure
how to correct them.

Any suggestions?



"David McRitchie" wrote:

correction:
Unless you did something like format individual cells rather than
large groups of cells you are *NOT* likely to recover much space.