Excel VBA: Excel Version

Use Application.Version property to find out the version of Microsoft Excel. Useful to check for Microsoft Excel version to test the number of rows.

Example Syntax:

MsgBox (Application.Version)

Version Number:

  • 15.0 – 2013
  • 14.0 – 2010
  • 12.0 – 2007
  • 11.0 – 2003