Table Name

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.
 
P

p45cal

With VBA, How do you determine the table name of the current table?
am
talking about the table name that is created when you select "Forma as
Table". Thanks.
Click to expand...




Selection.listobject.name
or
Activecell.listobject.name
 
G

Gary''s Student

How about:

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