Headers

  • Thread starter Thread starter Joan
  • Start date Start date
J

Joan

Is there a way I can create 2 custom headers for one
worksheet ? I want to print part of the worksheet that
contains the bank transactions with a header that
says "bank transactions", and another that contains the
trust transactions with a header that says "trust
transactions"

Thanks, Joan
 
Hi Joan
only with a macro. You may try the following code:

Sub print_different()
With ActiveSheet.PageSetup
.CenterHeader = "Bank Transactions"
ActiveSheet.PrintOut From:=1, To:=2
.CenterHeader = "TrustTransactions"
ActiveSheet.PrintOut From:=3, To:=4
End With
End Sub
 
Back
Top