Rows to repeat at top of each page
 

I have created an Excel spreadsheet with the rows repeating at the top of
each page. I do not want these rows to repeat on the final page but I also
do not want the last page to be a separate sheet. Is this possible?

Rows to repeat at top of each page
 

No. Someone could possibly write a VBA subroutine to print the first few
pages, fix the headers and then print the last page.
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Jane" wrote in message
...
I have created an Excel spreadsheet with the rows repeating at the top of
each page. I do not want these rows to repeat on the final page but I
also
do not want the last page to be a separate sheet. Is this possible?

Rows to repeat at top of each page
 

Have you tried fiddling with this?
File Page Setup Sheet Rows to repeat at top

Hope that helps,
Ryan---

--
RyGuy


"Bernard Liengme" wrote:

No. Someone could possibly write a VBA subroutine to print the first few
pages, fix the headers and then print the last page.
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Jane" wrote in message
...
I have created an Excel spreadsheet with the rows repeating at the top of
each page. I do not want these rows to repeat on the final page but I
also
do not want the last page to be a separate sheet. Is this possible?

Rows to repeat at top of each page
 

A possible solution:
Assuming all data is on one worksheet, create all your pages, for printing,
below each other down the worksheet except for the last page (the one you do
not want the headers on. Leave a column blank and create the last page (that
doesn't require headers) alongside page one (i.e. start in Row 1)
Highlight only the pages with data for printing as the 'setprint area'.
Look at your worksheet using Page Break Preview. Check pagebreaks are correct.
Then print: the only draw back, you need to specify the print page range
(e.g. page 1 to page ?) else you'll get a blank sheet of paper for every
printed page.
Hope this works for you.
Regards
Ron

"Jane" wrote:

I have created an Excel spreadsheet with the rows repeating at the top of
each page. I do not want these rows to repeat on the final page but I also
do not want the last page to be a separate sheet. Is this possible?

Rows to repeat at top of each page
 

Sub Test()
Dim TotPages As Long
TotPages = Application.ExecuteExcel4Macro("GET.DOCUMENT(50)")
With ActiveSheet.PageSetup
.PrintTitleRows = "$1:$1"
ActiveSheet.PrintOut From:=1, To:=TotPages - 1
.PrintTitleRows = ""
ActiveSheet.PrintOut From:=TotPages, To:=TotPages
End With
End Sub

Credit an assist to Ron de Bruin

http://www.rondebruin.nl/print.htm#not


Gord Dibben MS Excel MVP

On Wed, 31 Oct 2007 04:16:02 -0700, Jane wrote:

I have created an Excel spreadsheet with the rows repeating at the top of
each page. I do not want these rows to repeat on the final page but I also
do not want the last page to be a separate sheet. Is this possible?