Excel VBA Printing Footers

[vaneagle]

I have the following code:

Please Login or Register  to view this content.

what I want is the store and tradedept to print on the line below the 'Printed &D &T' and not on the same line... any ideas?

[davesexcel]

Hi,
If you go to page setup and you are able to set the footer the way you want, then you should be able to use the macro recorder to set the footer
will look something like this

Please Login or Register  to view this content.

Chr(10) is the enter key code

[vaneagle]

Hi,
If you go to page setup and you are able to set the footer the way you want, then you should be able to use the macro recorder to set the footer
will look something like this

Please Login or Register  to view this content.

Chr(10) is the enter key code

Thanks for that. Works a treat...

didn't think to use the macro recorder!!