this has to be the stupidiest error ever..."too many formats!" but CAN'T DELETE ANY FORMATS...

[sadams1]

hello All,
As you may be able to sense, the level of frustration with this is off the charts...I've read through the posts here & elsewhere online but have not found a way around this one. From what I've found, there's a "4,000 limit" to the number of formats...OK...I've been diligent about streamlining as much of the formatting in a large workbook as possible, there are no "conditional formats", I've deleted multiple sheets thinking this would take down the number of formats but nope!
What on God's green earth is this???

 

[Micron]

Usually it is enough to put your cursor in the code and press F8, then repeat F8 for each line. If you want to resume normal running then you click the 'run macro' button on the editor toolbar. Pressing F5 would probably do the same. As for break point(s) any line that you know will be executed will do. That can even be the first line.

Some code can't be run that simply as it may need parameters to be passed to it first.

 

[Edgar_]

@sadams1
Do you have a sample file?

 

[Alex Blakenburg]

Change this line:

Dim strMsg as Long

Thanks Joe, last minute tweaks so often come back to bite you.

 

[Joe4]

No worries!
I think you have caught a few of my blunders in the past!