ActiveSheet.PageSetup.CenterHeader = "yourCheader"
ActiveSheet.PageSetup.RightHeader = "yourRheader"
ActiveSheet.PageSetup.CenterFooter = "yourCfooter"
etc...

Regards,
Stefi

€žGer€� ezt Ã*rta:

Hi

Can anyone tell me how to create a header and a footer in excel from a
vb project. I can create the workbook and add text etc to the sheets
but i dont know how to create a header & footer.

Please help

Thanks