Choose Name from the Insert menu and then choose Define Excel displays the Define Name dialog box In the list of names shown in the dialog box, click once on the name whose reference you want to change (In this case, choose MyRange) The existing reference should show up in the Refers To box at the bottom of the dialog box If you only have 1 table on the ActiveSheet, you can rename it using this Code Sub RenameTable () With ActiveSheet ListObjects (1)Name = "MyTableName" End With End Sub Note that if that name is already being used in the target Workbook, Excel will make a unique name like "MyTableName_1" 1 So you may want to reconvert the Table into a Range (Right click on any cell in the Table and Table > Convert to Range) 2 Reselect the same range (including the header row) and press CtrlF3 > New and in the name box, type any text which describes the data in your table 3 Reselect the same range (including the header row) and press CtrlT
How To Sort High To Low Numbers In A Pivot Table In Excel
