Macro exceeded 64kb , therefore doesn't want to run , can i somehow make it more fine tuned?

[Dolsab]

Hello guys!

Probably someone else before me already posted this , but i have made a macro that makes a sum up of a 1.5k row and 6 column storage database , my question is , since my macro is around ~25k lines and 80kb , other specifications of the macro would be that it has a lot of sumifs and then it is applied to 250+ rows and around 45 columns. Can i somehow fine tune it so the excel won't have a problem running it , or should i just cut it in half? Thanks in advance for the suggestions.

Best Regards, Chris

 

[davesexcel]

Can you remove all the 'ActiveWindow.scrollrow=' lines?

 

[mse330]

Welcome to the forum … You would have a higher chance get your issue resolved if you post copy of your code for the people to see it. Copy your code & past it in the thread (not as a picture) between code tag which is indicated like <vba/>