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,
Scott

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
activesheet.pagesetup.leftfooter=range("a1").value
activesheet.printout
end sub

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

Dax.