print header row on all pages except last page
 

I would like to print a worksheet that is 12 pages and repeat rows on 11
pages except the last one since the the last page is the total page. HELP!!!

print header row on all pages except last page
 

The first part is easy enough. Filepage setup Sheet tab. Enter the rows you
want to repeat on EVERY page.

This will reprint yoru specified rows on each page of teh print out. It
will, however, also print on the last page. Maybe one of the MVP's has a
solution to eliminate them on the last page!

HTH

"Woofaloo" wrote:

I would like to print a worksheet that is 12 pages and repeat rows on 11
pages except the last one since the the last page is the total page. HELP!!!

print header row on all pages except last page
 

Yes thanks. I have the "all pages" covered. Someone told me it's a formula
to place in the Print Titles in the page setup. I am "Formula Ignorant" so I
need help....It seems that you should be able to un-include rows or stop a a
particular row.
Thanks again....

"JR Hester" wrote:

The first part is easy enough. Filepage setup Sheet tab. Enter the rows you
want to repeat on EVERY page.

This will reprint yoru specified rows on each page of teh print out. It
will, however, also print on the last page. Maybe one of the MVP's has a
solution to eliminate them on the last page!

HTH

"Woofaloo" wrote:

I would like to print a worksheet that is 12 pages and repeat rows on 11
pages except the last one since the the last page is the total page. HELP!!!

print header row on all pages except last page
 

Woof

Sub rows_to_repeat()
With ActiveSheet.PageSetup
.PrintTitleRows = "$1:$1"
ActiveSheet.PrintOut From:=1, To:=11
.PrintTitleRows = ""
ActiveSheet.PrintOut From:=12, To:=12
End With
End Sub


Gord Dibben MS Excel MVP

On Wed, 10 Jan 2007 12:07:01 -0800, Woofaloo
wrote:

I would like to print a worksheet that is 12 pages and repeat rows on 11
pages except the last one since the the last page is the total page. HELP!!!