| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding a column to a table
I'm trying to add a column to a table in excel using vba. Here is the code I
have. Dim tblData As ListObject Dim calendarWeek As ListColumn tblData = Sheets("Sheet1").ListObjects("Table1") <- Error Here calendarWeek = tblTop8Issue.ListColumns.Add calendarWeek.Name = "Calendar Week" calendarWeek.DataBodyRange = "WEEKNUM([Date])" I get an error on the first line saying Invalid Use of Property...Please help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table and adding a % column, that is not in original data | Excel Discussion (Misc queries) | |||
| Adding a column to an Excel table | Excel Discussion (Misc queries) | |||
| pivot table; adding kolomns to the base-table afterwards | Excel Programming | |||
| Column Chart - Adding text in the column in Excel 2007 | Charts and Charting in Excel | |||
| Adding a Custom Column based on an existing Column (EXPERT) | Excel Worksheet Functions | |||
Threaded Mode
