How is listheaderrows supposed to work?

  • Thread starter Thread starter Alfred Vachris
  • Start date Start date
A

Alfred Vachris

Listheaderrows is supposed to return the number of header rows in a
range. It seems to work OK if you have one or two rows of headers. But
it does not seem to work if there are more than two rows of headers.
Any suggestions?
Thanks Al Vachris
 
It only appeared to work with up to two header rows for me as well. That
may be the limit. For example, a manual sort would recognize two headers
rows, but not three or more
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Post my named ranges in column A 10
Adjust code to run anywhere on sheet 3
Modify Claus code "Sub Array_Var_Column_Sort()" 27
Find Specific Rows in Range and Create New Tab 18
Exclude header row when copying autofilter results? (XL2003) 1
How could I split a spreadsheet containing 600 rows, so there's 100rows in each new workbook 6
Sorting columns horizontally 2
Fill Down to Last Value 3

Back
Top