Printing an '&' (ampersand) in the footer

[plwhittington]

Can someone tell me how to print an '&' (ampersand) in the footer? Iam using a macro to populate the footer and have tried (1)using Chr(38) and (2)including it in a string (ex. "A & W"). It just sees it as a non-character and prints nothing. Thanks!

 

[Scott Huish]

If you want an & symbol in the header or footer, just use two ampersands:

ActiveSheet.PageSetup.CenterFooter = "A && W"

 

[plwhittington]

Thanks!!

Thanks Hotpepper! Worked great!