O'Reilly logo

Excel 2016 VBA and Macros by Tracy Syrstad, Bill Jelen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required