Different Header on First Page

  • Thread starter Thread starter SharonJo
  • Start date Start date
S

SharonJo

MS Word allows you to have a different header on the first
page. Is there a way to do this is Excel? I have a large
spreadsheet and beginning on page 2 I would like the
header to include: (Continued).
 
One way to print different headers
Change it yourself the how you want it

Sub test()
Totpage = Application.ExecuteExcel4Macro("GET.DOCUMENT(50)")
With ActiveSheet.PageSetup
.CenterHeader = "&8Page &8&P & of &N"
ActiveWindow.SelectedSheets.PrintOut From:=1, To:=1
.CenterHeader = ""
ActiveWindow.SelectedSheets.PrintOut From:=2, To:=Totpage
End With
End Sub
 
Back
Top