ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How is listheaderrows supposed to work? (https://www.excelbanter.com/excel-programming/278097-how-listheaderrows-supposed-work.html)

Alfred Vachris

How is listheaderrows supposed to work?
 
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

Tom Ogilvy

How is listheaderrows supposed to work?
 
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

--
Regards,
Tom Ogilvy



Alfred Vachris wrote in message
om...
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





All times are GMT +1. The time now is 12:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com