Best way to trap error to MsgBox "Too many cell formats"
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
|