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