Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 dividing by 100 when it's not supposed to. efhw Excel Discussion (Misc queries) 1 May 9th 09 01:47 AM
Is this function supposed to work? [email protected] Excel Worksheet Functions 6 May 8th 09 05:14 PM
Chart filling in dates that aren't supposed to be there Tschurin Charts and Charting in Excel 8 June 18th 08 02:43 AM
Excel If statement that is supposed to return a "" instead returns a 0 omalleyman Excel Worksheet Functions 1 October 5th 06 09:18 PM
When I publish a web page that's supposed to be interactave it be. Phil Excel Discussion (Misc queries) 0 March 14th 05 04:51 PM


All times are GMT +1. The time now is 01:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"