Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pagebreak
Can someone please tell me how i can detect if the row being populated has
broken through a page break. I have autofit set for my row heights and some rows are bigger than others, but i depends on the data. I need to print each page and need to know when to populate the first row of a page with the headings. Hope i'm clear enough Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
pagebreak
You don't need to know where your page breaks are to populate each page with
headings. You can do it using page setup. You don't mention your Excel version. I am yet to move to XL2007 (if ever). XL2003 File Page Setup Sheet tab Row to repeat at top: [click the button and click the row] Columns to repeat at left: [click the button and click the column] HTH -- Steve "sunilpatel" wrote in message ... Can someone please tell me how i can detect if the row being populated has broken through a page break. I have autofit set for my row heights and some rows are bigger than others, but i depends on the data. I need to print each page and need to know when to populate the first row of a page with the headings. Hope i'm clear enough Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
pagebreak
the page setup dialog box will automatically put your header rows at the top
of each page. No need to do it manually. File PageSetup Sheet tab Rows to repeat at top "sunilpatel" wrote: Can someone please tell me how i can detect if the row being populated has broken through a page break. I have autofit set for my row heights and some rows are bigger than others, but i depends on the data. I need to print each page and need to know when to populate the first row of a page with the headings. Hope i'm clear enough Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
pagebreak
i am usin Office 2000. There is no heading feature. Does that mean you
cannot detect pagebreaks using code? "sunilpatel" wrote in message ... Can someone please tell me how i can detect if the row being populated has broken through a page break. I have autofit set for my row heights and some rows are bigger than others, but i depends on the data. I need to print each page and need to know when to populate the first row of a page with the headings. Hope i'm clear enough Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cant move pagebreak in PageBreak View in Excel2003 | Excel Worksheet Functions | |||
PageBreak in VBA??? | Excel Programming | |||
find pagebreak | Excel Programming | |||
determine pagebreak using VBA | Excel Programming | |||
How to pagebreak | Excel Programming |