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?