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