Macro taking too long to run, macro is to make a summation based on specific criteria.

Hi SAFC,

This is the code that will help your code run faster sometimes by preventing the screen from being updated each time a change is made to a worksheet.

Please Login or Register  to view this content.

Sometimes it is necessary to set the ScreenUpdating back to true after your code finishes.

The most sluggish part of your code is the use of Select and Copy (as Marc pointed out). You should be able to get around this with an alternate code. I'll try and tackle it for you if you are still struggling.

Socrates

Any help that you can provide would be very grateful. I have added in the screen updating but it is still taking too long.

The backstory is that this macro will be placed in a lot of different workbooks that have the exact same structure and colored cells but there will be a lot of variation on the number of tabs but will always have the "master" tab. Before doing a distribution, I want to make this macro to take the format of the Master, create a summation tab and then loop through all the cells that are Orange or Yellow [FFCC99 and FFFFF99 respectively] and also for the line labeled "Gross Profit" in column A to add together E:Q, T, V:AG, AI & AK for all rows that have gross profit [Gross Profit is the only type in the file that isn't colored that needs to be added, thinking of changing it to gray [F2F2F2].]