Excel 2013 Preview: New Worksheet Functions

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

About Colin Legg

RAD Developer Microsoft MVP - Excel 2009 - 2014
This entry was posted in Microsoft Excel and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s