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.

Mike H.;691644 Wrote:

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.




Selection.listobject.name
or
Activecell.listobject.name


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: 558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=193364

http://www.thecodecage.com/forumz

How about:

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

--
Gary''s Student - gsnu201001


"Mike H." wrote:

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.