Table Name

  • Thread starter Thread starter Mike H.
  • Start date Start date
M

Mike H.

With VBA, How do you determine the table name of the current table? I am
talking about the table name that is created when you select "Format as
Table". Thanks.
 
How about:

Sub TableMike()
Dim ss As ListObject
For Each ss In ActiveSheet.ListObjects
MsgBox ss.Name
Next
End Sub
 
Back
Top