|Excel Developer Reference|
Returns or sets a String value that represents the name of the ListObject object.
expression An expression that returns a ListObject object.
By default, each ListObject object name begins with the word "List", followed by a number (no spaces). If an attempt is made to set the Name property to a name already used by another ListObject object, a run-time error is thrown.
The following example displays the name of the default ListObject object in sheet1 of the active workbook.
|Visual Basic for Applications|