Excel® 2013 VBA and Macros

28. What Is New in Excel 2013 and What Has 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

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

If you were using Excel 2003 (or older) before Excel 2013, almost everything you knew about programming Excel objects has changed. Basic logic still works (for loops, for example), but most objects have changed. This chapter reviews changes since Excel 2007–2010. In conjunction with reviewing those sections, you should also review information in this book on tables, sorting, and conditional formatting.

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