I was wondering if there's anywhere in Excel, or online, that I can use to see how the Functions in Excel are working.
The idea is that I'm starting to learn how to make UDFs, and do various things in VBA, and thought that if I could see how Excel actually executes Sum()
for instance, I can learn how to make my code tighter, take less space, etc.
Basically, where's the repository for how Excel's built-in functions work? Is that even available?
Edit: I understand that the formulas may be written in not-VBA. That's fine - I'm just curious if there's a way to see them, whatever language they're written in.
Edit2: The overall idea is that I'm learning C++/VBA/C#, and would like to see "official" functions just to learn how they work, and see if there are any ways to speed up code. OpenOffice functions are good too!