Viewing the code of built-in functions

[Jim]

Hi
I'd like to view the code of 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

(I've also posted this in excel.programming..before I found this forum!!)

 

[Bob Phillips]

Jim,

Not a chance. All written in C, and buried deep in the internals of Excel.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Norman Harker]

Hi Jim!

The most you'll get is Help which sometimes gives details of the
algorithm.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.