"Too Many Cell Formats" Got Fix! But ... need VBA Variable reset
 

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

"Too Many Cell Formats" Got Fix! But ... need VBA Variable reset
 

EagleOne wrote:
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



Maybe this can be useful for you:

http://exceltips.vitalnews.com/Pages..._Be_Added.html

--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy