Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determine last row before end of page on worksheet
I am trying to develop some reports in Excel from VB6.0. The reports
have multiple records that can span several rows. Each record has a commments field in it, so the height of a cell can very greatly from record to record. What I am trying to figure out is an easy way to determine what was the last row on a page in excel, so that when it goes to a new page, it will reprint the title and the column names. Currently I am calculating the height of every row and then based on if the pagesetup is landscape or portrait, comparing that number to the total height of the page to determine when the page ends...Is there a simpler way to achieve this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determine last row before end of page on worksheet
Have you tried setting the Rows to Repeat At Top property?
FilePageSetupSheetRows To Repeat at Top Hope this helps Rowan dclarkston wrote: I am trying to develop some reports in Excel from VB6.0. The reports have multiple records that can span several rows. Each record has a commments field in it, so the height of a cell can very greatly from record to record. What I am trying to figure out is an easy way to determine what was the last row on a page in excel, so that when it goes to a new page, it will reprint the title and the column names. Currently I am calculating the height of every row and then based on if the pagesetup is landscape or portrait, comparing that number to the total height of the page to determine when the page ends...Is there a simpler way to achieve this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to determine row of page break on modified presentation sheet? | Excel Discussion (Misc queries) | |||
Converting a muliple page worksheet to a single page worksheet | Excel Discussion (Misc queries) | |||
Determine page which row will print on | Excel Programming | |||
determine page number in Word document | Excel Programming | |||
Determine maximum length of a page | Excel Programming |