functions available for vba programmer

[lezawang]

Hi
I just want to clear the confusion I have about vba functions vs WorksheetFunction. Please correct me if I am wrong:

All VBA functions are listed here:

https://www.techonthenet.com/excel/formulas/index_vba.php

All excel functions (without vba, like open sheet and type = then function name) are listed below, by the way these functions can be called in vba code if you use worksheetfunction object

https://docs.microsoft.com/en-us/office/vba/api/excel.worksheetfunction

Now combining these 2 set of functions, user can write VBA code and use them all.

Here is my another question, if the above is right, then why =sum() is not in any list? Thank you very much

 

[shg]

why =sum() is not in any list?

https://docs.microsoft.com/en-us/office/vba/api/excel.worksheetfunction.sum

 

[lezawang]

Sorry I should have looked harder. Thank you.