MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Simple footer question

Posted by ScottR on February 19, 2001 10:53 AM

I'm trying to get an ampersand to show up in my footer via Page Setup Custom Footer.

I want M & A, instead I get M A

Also, is there a way to put cell contents into a footer via a cell ref in Page Setup Custom Footer?

Thanks in advance,

Posted by Dax on February 19, 2001 11:56 AM

For the first question put M && N.

For the second use this macro:-

sub PutCellContentsIntoFooter
end sub

Obviously you'll need to change the A1 in the macro to whatever cell you are referring to.