Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
"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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Too many different cell formats" error in Excel | Excel Worksheet Functions | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Input Cell in One variable data table | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Linking a cell to another workbook cell based on a variable name | Excel Discussion (Misc queries) |