How can I make a header in Excel appear on the first page only?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know how to put a header on an excel spreadsheet but is there a way to make
it appear on the first page only?
 
Code from Ron de Bruin's site on Print Tips.

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

Sub Test()
Dim TotPages As Long
TotPages = Application.ExecuteExcel4Macro("GET.DOCUMENT(50)")
With ActiveSheet.PageSetup
.RightHeader = "Your Header info"
ActiveSheet.PrintOut From:=1, To:=1
.RightHeader = ""
ActiveSheet.PrintOut From:=2, To:=TotPages
End With
End Sub


Gord Dibben Excel MVP

On Wed, 27 Apr 2005 14:51:19 -0700, "Excel headers" <Excel
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Headers in Excel 1
How pull ID#s that meet specific "yes" requirements 3
headers and footers 2
Different First Page? 2
Vertical Header in Excel 2
Row 1 HEADERS on EVERY printed page 2
Different First Page 1
Having a Header on only the first page 1

Back
Top