Thread: HeaderRowRange
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] oldyork90@yahoo.com is offline
external usenet poster
 
Posts: 59
Default 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