Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Table Name
How do I get the name of the current table? I am talking about when I use
the HomeFormat as Table (In the Styles section) and then format data as a table. Typically Excel assigns the name Table1, Table2, etc. How can I determine the table name in VBA? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Table Name
here you go
ActiveSheet.ListObjects.Add(xlSrcRange, Range(ActiveCell.CurrentRegion.Address), , xlYes).Name = "ABCD1" But the only catch over here is your cursor should be with in the table. I mean if you have data in range "A1:E40", then your cursor should be with in this range. If the cursor is in cell F3 then this code will work but not as you want it to. regards Heera Chavan "Mike H." wrote: How do I get the name of the current table? I am talking about when I use the HomeFormat as Table (In the Styles section) and then format data as a table. Typically Excel assigns the name Table1, Table2, etc. How can I determine the table name in VBA? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivit table- cell on spread sheet referencing pivot table field | Charts and Charting in Excel | |||
entry removed from source table remains in pivot table pull down | Excel Worksheet Functions | |||
PIVOT TABLE - Summary Table into a Databasae Table. | Excel Worksheet Functions | |||
VBA Code for a pivot table to open database and to reference table current page | Excel Programming | |||
create a source table from a special pasted value dynamic crossed table | Excel Programming |