Most of the new worksheet functions were listed in the last post which looked at changes in the Excel Object Model. To complete the list, the new worksheet functions which aren’t exposed in the WorksheetFunction class are:
| FORMULATEXT() |
| SHEET() |
| SHEETS() |
I also noticed that CEILING.PRECISE() and FLOOR.PRECISE() have been hidden to discourage their use in the Excel UI since they’re superseded by their .MATH() counterparts.
Let me know if I’ve missed any new ones out.
Advertisements
