Procedure Too Large Issue

I have Worksheet Calculate event embedded in a worksheet that fires each time separate arrays change that I am monitoring. I log different statistics based upon if these arrays change or not. There are a lot of lines of code related to the arrays I monitor. Hence the issue of closing in on the >64Kb compile procedure limit. I am looking for advice on how to consolidate some of this code into a separate module or class module that is called on its own to reduce the number of characters to get under 64Kb and achieve the overall task of the Worksheet Calculate event. Below is a portion of the code. I am looking to consolidate the L thru W "strformula" references to Sheet1 & Sheet5 to clean it up and get it under the 64Kb limit.

Please Login or Register  to view this content.

This code continues on for ~1,000 lines from MyArr to MyArr46 & from KeyCells to KeyCells46

Hi, just to be practical, I have similar files with formulas with multiple IFS and more.
What I would suggest is to build al the formulas using a normal Module.
Like you did is good, dispable all calculations, events and screen updates first.
Complete all the formula building that, without the file to is something nobody can check for you.
After all the basics are set then reset all the evnets and just run the code

Please Login or Register  to view this content.

Again without a sample file it's impossible to really tell you what to change and see how it's actually built

@mjac101, see if the following shortened version works for you:

Please Login or Register  to view this content.

Edit: I'm not sure what 'PopulateBA', ' PopulateBA2', etc is. If those are procedures that you are calling then that section could be shortened to:

Please Login or Register  to view this content.

That would leave the number of lines of code = 84 ... about 1/3 less than your original code.