Читать книгу Excel VBA Programming For Dummies - Dick Kusleika - Страница 26

This book is written for the desktop versions of Excel 2019 and Excel 2021. If you don’t have one of those versions, there’s a slight risk you’ll get confused in a few places, but mostly it will just work.

If you plan to distribute your Excel/VBA files to other users, it’s vitally important that you understand which versions of Excel they use. People using older versions won’t be able to take advantage of features introduced in later versions. For example, if you write VBA code that references cell XFD1048576 (the last cell in a workbook), those who use a version prior to Excel 2007 will receive an error because those pre-Excel 2007 worksheets had only 65,536 rows and 255 columns (the last cell is IV65536).

Excel 2010 and later also have some new objects, methods, and properties. If you use these in your code, users with an older version of Excel will receive an error when they run your macro — and you’ll get the blame.