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