VBA Corruption = "We found a problem with some content in XXXXX.xlsm."

[knykil]

Hi All,

I continue to have an issue with my forecast model vba, where I receive the follow message when opening: "We found a problem with some content in xxxxx.xlsm. Do you want us to try to recover as much as we can?" The issue only occurs after I build out all of my segment/product tabs. In other words, when I have all my VBA in place, as well as my non-colored tabs, as well as the pipeline tab, and one single segment/product tab (P MFI), there is no issue. However, when I begin to build out all of the color tabs and try to save, I receive this message and also whenever I try to reopen it.

I've inherited this code so I'm only about 95% comfortable with it as of now.

Looking around the forum, I see that similar issue have been addressed where the answer was maxing out the data validation character limit of 255. I know what data validation is on the front end when creating a list, but I don't know where to begin to diagnose this problem as I don't believe any data validations exist.

SEND HELP!

THANKS!

[Fluff13]

When using sortfields.add you should always clear them first. So you need to un-comment this line of your code

Please Login or Register  to view this content.

[knykil]

When using sortfields.add you should always clear them first. So you need to un-comment this line of your code

Please Login or Register  to view this content.

Absolute, genius! Thank you so much for finding the needle in the hay stack! I really do appreciate your assistance and sharing your expertise.

Cheers!

[Fluff13]

You're welcome & thanks for the feedback.