Formatting page header/footer using cell values.

[Pygmalion]

Hello experts!

Excel has a nice option to format various parts of a chart using cell
values. Can the same be done for headers/footers, e.g. that the header
displays value of cell A5.

Thanks, Marko.

 

[ankur]

Hi Marko,

Try this...

ActiveSheet.PageSetup.CenterFooter = Range("A5").Value

Regards
Ankur/Kanchan
www.xlmacros.com

 

[Pygmalion]

Thanks!

So I suppose there is no way to put cell formula into header...

Regards,

Marko

ankur je napisal:

 

[Dave Peterson]

Not directly.

But you can put a formula into your code or retrieve the value from a cell with
a formula.

with worksheets("sheet9999")
.PageSetup.CenterFooter _
= .Range("A5").Value + (.range("b99").value / 3)
end with