Its very difficult to answer your question: the timing difference is highly
dependent on:

- what kind of function you are creating
- how you code the VBA UDF
- how calculation is initiated
- the state of the VBE environment

but in general a VBA UDF will be slower than a native excel function unless
the VBA UDF implements an algorithm/method which is superior to the native
function.

Charles
______________________
Decision Models
FastExcel 2.1 now available
www.DecisionModels.com

"MrShorty" wrote in
message ...

General concensus is that UDF's are slower in terms of calculation time
than native Excel functions. My observation (on a 450 MHz machine) is
that the longer calculation time is imperceptible. At 100 MHz, it was
a perceptible difference, but was never significant.

If this is a one time thing, and you'ave already got the spreadsheet
built and debugged, it's not to your advantage to re-do the formula as
a VBA function.

As an open question to the group: Does anyone have an estimate of how
much longer it takes for Excel to calculate a UDF versus using native
functions for the same calculation?


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile:
http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=472454