- because Microsoft know all the ins and outs of Excel and the operating
system and so can take full advantage
- because VBA is not compiled
- because Excel uses compiled C code which is much faster than VB or VBA
- etc.

--

HTH

RP

"davidm" wrote in
message ...

Can someone explain why EXCEL's built-in functions (like SUM, AVERAGE,
IRR, NPV) cannot be replicated -in terms of efficiency and speed -using
VBA? As a related issue, what language does EXCEL's code source use?

Just curious.

David.


--
davidm
------------------------------------------------------------------------
davidm's Profile:
http://www.excelforum.com/member.php...o&userid=20645
View this thread: http://www.excelforum.com/showthread...hreadid=501971