Excel 2016 VBA and Macros

28. What’s New in Excel 2016 and What’s Changed

In This Chapter

If It Has Changed in the Front End, It Has Changed in VBA

Learning the New Objects and Methods

Compatibility Mode

Next Steps

This chapter reviews changes since Excel 2007–2013. In conjunction with reviewing those sections, you should also review information in this book on tables, sorting, and conditional formatting.

If It Has Changed in the Front End, It Has Changed in VBA

If you were using Excel 2003 (or older) before Excel 2016, almost everything you knew about programming Excel objects has changed. Basic logic still works (for loops, for example), but most objects have changed.

If you have been using Excel 2007, 2010, or 2013, there are still a few changes to consider, and ...