Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting a Table Column
Why not
From: Set rngBootStatTable = wkshtSiteWorksheet.Range( _ strTableName & "[RunTime]") to: Set rngBootStatTable = wkshtSiteWorksheet.Range(RunTime) or Set rngBootStatTable = wkshtSiteWorksheet.Range(strTableName).offset(0,Ru nTime).entirecolumn "Steve Haack" wrote: I have several worksheets (more then 50). Each has a table that has several coumns of data. Each table is named with the name of a site, such as "tblSite1". In code, I wan to go through each of the tables, select a specific column called RunTime and change it format to a date. what I am trying to do is this (psuedo code): Set wkshtSiteWorksheet = ActiveWorkbook.Worksheets(strSiteName) Set rngBootStatTable = wkshtSiteWorksheet.Range( _ strTableName & "[RunTime]") rngBootStatTable.NumberFormat = "m/d/yyyy" It fails on setting the RunTime column range into rngBootStatTable Can someone tell me why this does not work, and how to properly reference a Column that is defined in an excel table? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting examples from a table | Excel Discussion (Misc queries) | |||
Pivot Table - Selecting the GrandTotal Column in VBA xl2003 | Excel Programming | |||
Text to column and selecting values based on a different column | Excel Worksheet Functions | |||
Text to column and selecting values based on a different column | Excel Worksheet Functions | |||
Text to column and selecting values based on a different column | Excel Discussion (Misc queries) |