Prev: Testing object value
Next: Autocomplete date for cell based on other cell values
From: Mike H. on 6 Apr 2010 12:32
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.
From: p45cal on 6 Apr 2010 13:02

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/showthread.php?t=193364

http://www.thecodecage.com/forumz

From: Gary''s Student on 6 Apr 2010 13:23
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.
 | 
Pages: 1
Prev: Testing object value
Next: Autocomplete date for cell based on other cell values