I am trying to format headers and footers in an Excel 2003 Spreadsheet using VBA.

More specifically I would like to justify the the text in the Centre and Right hand Headers/Footers to align to the left. When I use the &L operator it moves the text into the Left hand header/footer. I've tried padding with spaces to manually align text, but this has no effect no matter how many spaces I input to the text.

I've also tried putting all the text into the Left hand header/footer in the hope that it will stretch across the page, but this only gives me an error (the total text is less than 255 characters).

One final point - I would like to put an ampersand (&) in as text but Excel always reads this as an operator prefix even when I try adding it as Chr(38) rather than the actual & sign. Can this be got around?

Thanks for any help or advice.