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