pagebreak

S

sunilpatel

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
 
A

AltaEgo

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
 
S

slarbie

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
 
S

sunilpatel

i am usin Office 2000. There is no heading feature. Does that mean you
cannot detect pagebreaks using code?
 
Top