Excel Built-in Functions Code Behind Them

[Verysheyn]

Hello everyone,

Is there a way to see the code of the excel built-in functions? Are these functions written on VB language? If not, is there anyway to see how are they built?


Regards,

Verysheyn

 

[RickXL]

Hi,

As far as I know you can't see the code behind the functions.
And, no, they are not written in VBA. In fact VBA is often slower than using the worksheet functions.

 

[Verysheyn]

Hi RickXL,

I'm sorry to hear that. I was hoping to find out how exactly did excel functions worked, I mean I can figure out what do they do but not how they were written.

Thanks for replying!


Regards

Verysheyn

 

[RickXL]

No problem - sorry I couldn't help.