View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Return no of rows per page

Think you would have to examine the horzontal page breaks collection
hpagebreaks

However, unless you put data in your worksheet first, they probably won't
tell you much. You may need to put in your data and then work down from the
top, adding lines and putting in your headers.

--
Regards,
Tom Ogilvy

"Neil Waterworth" wrote in message
...
Hi,

I'm fairly new to this, but is there a property which returns the number

of
rows per printed page.

Specifically, I want to setup the page, then populate a worksheet, but
insert column headers on each page. There may be a better way to do this.

Thanks for any help,
Neil