The previous post provided VBA code for a number of trigonometric functions, most of which are already available in Excel. Why bother you may say, why not just use the WorksheetFunction object? The numbers below provide the answer:
| Time to calculate ATan2() 65,536 x 16 times | ||
|
XL2007 |
XL2000 |
|
| VBA ATn2() |
1.60 |
1.21 |
|
Worksheetfunction |
14.20 |
3.06 |
With Excel 2007 using a UDF in preference to Worksheetfunction gives a speed improvement of almost 10 times. With Excel 2000 the difference is not so dramatic, but still a worthwhile 2.5 times improvement.
Being picky –
But not for spellers: An Excel blog for engineers and scientists, and an ->egineering<- and science blog for Excel users.
LikeLike
mrt – OK, fixed.
And congratulations on getting the first comment in 🙂
LikeLike
Hi Doug –
I followed the link here from Daily Dose of Excel, and I’ll be back, for I’m definitely not one of those $$$ guys.
I really like your concept.
…mrt
LikeLike
Pingback: Excel 2007 performance - feedback please « Newton Excel Bach, not (just) an Excel Blog
Pingback: Worksheetfunction vs UDF - 2 « Newton Excel Bach, not (just) an Excel Blog
Pingback: Excel VBA Performance in Office 2007 - Code For Excel And Outlook Blog
Pingback: Pendiente compatibilidad 2003/2007 mucho mas lento