Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return no of rows per page
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return no of rows per page
Go to Page Setup - Sheet - Rows to Repeat at Top or Columns to Repeat at
Left. This automatically puts column or row headers on each printed page. "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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return no of rows per page
Thanks. I'll try these ideas.
"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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return no of rows per page
Thanks,
ActiveSheet.PageSetup.PrintTitleRows = "$1:$2" got me there. Neil "Barb Reinhardt" wrote in message ... Go to Page Setup - Sheet - Rows to Repeat at Top or Columns to Repeat at Left. This automatically puts column or row headers on each printed page. "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Page Breaks- Printing selected rows on same page | Excel Discussion (Misc queries) | |||
Conditional page break if merged rows won't fit on the page. | Excel Worksheet Functions | |||
Is there a function that will return the page number? | Excel Worksheet Functions | |||
Copy Rows and insert these rows before a page break | Excel Programming | |||
Return an array of all page ranges in a sheet? | Excel Programming |