Formatting page header/footer using cell values.

  • Thread starter Thread starter Pygmalion
  • Start date Start date
P

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.
 
Thanks!

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

Regards,

Marko

ankur je napisal:
 
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
 
Back
Top