Afterthought and a couple of tips:

You will need to go through page setup and set the headers before you begin.
if you want the macro to do the headers then the easy way is to record a
macro while inserting them and then insert it where required.

Tip 1:
Your code loops through each worksheet indicating that you want to print
multiple worksheets. Therefore if the headers are the same on all worksheets
then you can save yourself some time by selecting all the worksheets. (Hold
the Ctrl and click on each individual tab) and you only have to set the
headers once and it will be applied to all of the selected worksheets.

Tip 2:
You can also select all the worksheets as one print job and it will print
all the worksheets and if you have page numbering, it will number them all in
sequence. You can run page setup all together as per Tip 1 or you can run
page setup individually with different setup for each worksheet and still
select them all for the print job. However, if printing from a macro, instead
of using
For Each wsSheet In Worksheets, you would need to select all the required
worksheets. You can record a macro to get the code for this.



Regards,

OssieMac