Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Syntax for using table and column names
I can't figure out the syntax to use table and column names.
Assume I have a worksheet named "ClubMembers" containing a table named "Members" with columns "Name" and "Number". Here is a simplified snippet illustrating a dumb way to refer to them. How do I use table and column names more elegantly? Dim oListRow As ListRow For Each oListRow In _ Worksheets("ClubMembers").ListObjects("Members").L istRows oListRow.Range.Cells(1, 1) = "No Name" oListRow.Range.Cells(1, 2) = 0 Next oListRow Thanks for your help, Jim Thompson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add data to 2007 table based on column names? | Excel Programming | |||
Macro - Copy Table Column & Row Names When Codition Is Met | Excel Discussion (Misc queries) | |||
range names in macros - syntax again | Excel Programming | |||
Return a value from a table using Column and row names as input? | Excel Discussion (Misc queries) | |||
Add Database Names, table names & related fields from table in combo box | Excel Programming |