E
EagleOne
2003 & 2007
Seem to be running into this error more often than in the past.
Personally, I know how to avoid it but I review others' worksheets. As part of my review, I run a
series of macros. For some reason, I can not seem to trap this error.
My macro seems to finish normally yet all the special formatting (in my macro) stops a some point
probably at 4086 formats.
I would like to know when this happens with a message box so than I can save the file, re-open it
and continue where the macro crashed.
I have If err.number MsgBox "Too Many Formats" all over the code but ...
Thanks for any thoughts
EaglrOne
Seem to be running into this error more often than in the past.
Personally, I know how to avoid it but I review others' worksheets. As part of my review, I run a
series of macros. For some reason, I can not seem to trap this error.
My macro seems to finish normally yet all the special formatting (in my macro) stops a some point
probably at 4086 formats.
I would like to know when this happens with a message box so than I can save the file, re-open it
and continue where the macro crashed.
I have If err.number MsgBox "Too Many Formats" all over the code but ...
Thanks for any thoughts
EaglrOne