Table Name
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. |
Table Name
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 |
Table Name
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. |
All times are GMT +1. The time now is 08:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com