A couple of questions on how to take this a step further, if I may...

1) When I set up the headers/footers manually via
File-PageSetup-Header/Footer, I am able to make the header/footer into
multiple lines by pressing carriage return inside the text box. How can I do
the equivalent within macro code? Via some format code perhaps?

2) Is there a place somewhere that lists all the possible format codes that
can be used?

Thanks a lot.


"Incidental" wrote:

hi

have a look at this site by chip pearson it should help you out, the
site has loads of other very helpful stuff on there well worth
checking out

http://www.cpearson.com/excel/headfoot.htm

hope it helps