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
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