Thanks for your help Bill. That improved the speed a little bit. I'm not
sure if SP is the cause of my sheet being so slow. I guess it would be
best to replace the sumproduct formulae with code. It would follow the
same logic as the SP formula:
=SUMPRODUCT(--($B$4:$B$1002<=B4),--($M$4:$M$1002="PROD"),--($O$4:$O$1002="O"))
Would you know of a way that I might go about doing this? Thanks again
for your help.
Bob Phillips Wrote:
Got my calculate and calculation back to front
Application.Calculation = xlCalculationManual
and
Application.Calculation = xlCalculationAutomatic
what about the formulae?
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
--
chris46521
------------------------------------------------------------------------
chris46521's Profile:
http://www.excelforum.com/member.php...o&userid=35909
View this thread:
http://www.excelforum.com/showthread...hreadid=569999