2003

Finally got a workaround for this error. That said, part of the
workaround requires that I save and close the file. then re-open it to
continue the sheet processing.

Therefore, I am guessing that the internal "Too-Many?" variable that XL
watches to raise the flag: "Too Many Cell Formats" must clear each time
the file closes.

Also, as long as I do not select the previous "completed" worksheets
the "Too-Many" variable starts anew.

Depending upon how many cells-in-use each w/s's has, I process a few
then save the file, close it and re-open it.

MY QUESTION:

Is there a way in VBA, to accomplish the same "Too-Many" variable reset
as is done by saving, closing and re-opening files?

Thanks,

EagleOne