![]() ![]() Then a Microsoft Excel dialog box pops up with the version number displaying. VBA code: find Excel version Sub MyVersion()Ĥ. Copy and paste the below VBA code into the Module window, and then press the F5 key to run the code. Press Alt + F11 to open the Microsoft Basic for Applications window.Ģ. See screenshot:īesides the above methods, you can also find Excel version with VBA code.ġ. ![]() In the Excel Options dialog box, click Resources in left pane, then you can see the Excel version in the about Microsoft Office Excel 2007 section. Click the Office button > Excel Options.Ģ. Then you can see the Excel version is displaying in the About Microsoft Excel section. Then you will find out your Excel version in the About Microsoft Excel dialog box.ġ. You can do as follows to find the version of Excel 2013/2016.ġ. In this article, we will show you methods of looking for the version information of your Excel. In some cases, you may need to know the version information of Excel you are using. "Title.D10" is substituted for the last cell of the table.Ħ.How to find the version of Excel you are using now? For data tables with both one row and one column of headers:."Row Title.D10" and "=Sheet1!$A$1", where A1 is substituted for the first cell of the table and D10 is substituted for the last cell of the table. For data tables with one column of row headers:."Column Title.D10" and "=Sheet 1!$A$1", where A1 is substituted for the first cell of the table and D10 is substituted for the last cell of the table. For data tables with one row or column headers:.Check that each data table corresponds to a Name and that the Name and Range follow the following formats: ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |