Thanks for the info Bob. How would you suggest that I change SP? Is
there a more efficient way of using a different formula than SP?
Thanks!

Bob Phillips Wrote:
Who's Bill?

I think you should explore improving the SP before going to code. Code
can
be better in some cases, but it is inherently slower than built-in
functionality, so you have to use a different technique to get the
speed
improvements. You can usually make a big difference with rewriting the
formulae.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"chris46521"
wrote
in message
...

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



--
chris46521
------------------------------------------------------------------------
chris46521's Profile: http://www.excelforum.com/member.php...o&userid=35909
View this thread: http://www.excelforum.com/showthread...hreadid=569999