Speed up/Streamline countifs/sumifs code/formula

Good Afternoon,

I am trying to speed up a portion of the following macro/formula, specifically the 1st and 3rd lines of code below. I believe the first line using countifs is the slow down as the data set is ~21k rows. Any assistance would be greatly appreciated. Thank you.

The first line looks for an order number (H4) that shows up in a named range (OrderNum) more than one time but in different locations.

The third line first checks to see of the previous test did in fact find the same order number in different locations. If so perform a sumif to see if the amounts net to zero.

Please Login or Register  to view this content.

Hi Alan,

Thanks for taking the time to look into this. I actually have the screen updating code in the macro. Also and surprisingly it actually runs slower when i use the application.calculation code.