How to print a header row on all but first page.

I have a database that starts on row 10 with header information in row 9 explaining the purpose of the data for each column. In rows 1 through 8 I have general information that when I print the database - I would want on the first printed page (as well as the beginning rows of the database) and have the remaining print pages be the remaining portions of the database but have the header row (row 9) at the top of each - like a header row.

I know how to goto FILE > PAGE SETUP > SHEET > ROWS TO REPEAT AT TOP: - but this will put row 9 at the top of ALL pages...which I want, but not on the first page.

Any suggestions? I'm ok with making a print button with a macro...but no idea where to begin with the vba code to do this.

Thanks,

GuruWannaB

Good evening GuruWannaB

This is not actually that easy to do. You need to do it in two stages. The first stage prints out page 1 without the titles. The next stage inserts the titles like this :

Please Login or Register  to view this content.

and then prints from page 2 onwards.

Have a look at John McGimpsey's examples here with headers and footers. If you really can't figure it I will help further - just not now 'cos it's bedtime.

HTH

DominicB