Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HeaderRowRange
I am trying to iterate thru column headers in a 2010 table
Dim oWs As Worksheet: Set oWs = Application.ActiveSheet Dim oLO_table As ListObject: Set oLO_table = oWs.ListObjects(TABLE_ACTUALS) Dim oRg_header_row As Range: Set oRg_header_row = oLO_table.HeaderRowRange Dim num_columns As Long: num_columns = oRg_header_row.Columns.Count Then I try and view all the names in a loop For ndx = 0 To num_columns - 1 title = oRg_header_row.Offset(0, ndx).value ... next I get nothing but nulls. Table is there, I can see it in the watch window. column count is correct. Where is my mistake? thank you |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
HeaderRowRange
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
HeaderRowRange
For ndx = 1 To num_columns Title = oRg_header_row.Cells(ndx) Next Thanks again Mr. Busch. These new, to me, objects can be very confusing. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|