Viewing built-in functions

[Jim]

Hi
I'd like to vioew some of the built-in functions of Excel 2000. I'm
particularly interested to learn how the RANK function works as I want to
try and build something similar...
Anyone know how to look at the code of a built-in function??
Thanks.
Jim

 

[Harlan Grove]

I'd like to vioew some of the built-in functions of Excel 2000. I'm
particularly interested to learn how the RANK function works as I want to
try and build something similar...
Anyone know how to look at the code of a built-in function??

AFAIK, the only way to see the code for any functions that come with Excel
(built-in or ATP) is to be hired by Microsoft as an Excel programmer
specifically responsible for maintaining those functions. I doubt there's any
other legal way to do so unless you're a lawyer with a rather broad discovery
order.