As Tom and Myrna have pointed out, VBA does have speed advantages under
certain circumstances. So, the general rule should be "in general, VBA
functions are more likely to be slower than XL-native functions."

For another example of when VBA can be faster, see
http://www.google.com/groups?selm=MP...4beed4898abb1%
40msnews.microsoft.com
--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Thanks Bob & Tom for the tip. I guess I will have to
rethink this some more. I am quite surprise that the VBA
would generally be slower though.
-----Original Message-----
Steve,

Generally speaking, as long as the formulae are
optimised, VBA will always
be much slower than built-in functions.

You can improve the speed of formulae if expressions are
repeated by storing
the repeated expression in a separate cell, e.g.

=IF(SUM(A1:A100)0,SUM(A1:A100,"")

store =SUM(A1:A100) in a separate cell, A999 say, and
use

=IF(A9990,A999,"")

meaning it only gets resolved once.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Steven Cheng" wrote in message
...
I am using a series of sumproducts that filter a table
of
data based on several criteria (e.g. if field1=X AND
field2=Y, etc...) and it would seem to be slowing the
file
in terms of the recalculation speed. I have turned the
spreadsheet to manual calculation as the result. Would
writing the code in VBA to do the same thing that I am
doing with sumproduct be a performance improvement?


.