Macro code too long: "Procedure too large" Error

I have a code that is way too long so I keep getting the error: "Procedure too large". Is there a way to fix it? I dont know how to write the code another way.



This is my code. This is just for 1. There are about 37. Maybe there's another way to do it.

the code is just if "K7" = 1 then do ALL that. (goes up to if "K7" = 37 do something, and maybe more)

The code works fine if I only do around 10 but anymore more than that is too much.



Any Ideas?

Please Login or Register  to view this content.