Way to display a formula result in header or footer?

[StargateFanNotAtHome]

Another thing I've wondered about for some time, is there a way to
display a calculation result in either the header or the footer?

i.e., say the sheet had grand total or $350.00, it would be neat to
have something like the header text say "Grand Total: $", then
whatever code such as, oh, [GrandTotal,G50], who knows how it would go
.... so that the grand total is displayed in either header or footer.

Thx! D

 

[JP]

Check out

http://www.codeforexcelandoutlook.com/blog/2008/04/udf-to-return-page-headersfooters-text/

If you wanted to set the left header:

ActiveSheet.PageSetup.LeftHeader = ' your calculation here


Let me know if it works!
--JP

 

[Gord Dibben]

Sub CellInFooter()
With ActiveSheet
.PageSetup.CenterFooter = .Range("A1").Value
End With
End Sub



Gord Dibben MS Excel MVP

 

[StargateFan]

Check out

http://www.codeforexcelandoutlook.com/blog/2008/04/udf-to-return-page-headersfooters-text/

If you wanted to set the left header:

ActiveSheet.PageSetup.LeftHeader = ' your calculation here

Kewl, so it _is_ possible. Learn something new every day.

Let me know if it works!

Will do! Thanks. D

--JP

Another thing I've wondered about for some time, is there a way to
display a calculation result in either the header or the footer?

i.e., say the sheet had grand total or $350.00, it would be neat to
have something like the header text say "Grand Total:  $", then
whatever code such as, oh, [GrandTotal,G50], who knows how it would go
... so that the grand total is displayed in either header or footer.

Thx!   D

 

[StargateFan]

Sub CellInFooter()
With ActiveSheet
.PageSetup.CenterFooter = .Range("A1").Value
End With
End Sub

Wow, thanks. Will try this one, too.

Cheers! D

Gord Dibben MS Excel MVP

Another thing I've wondered about for some time, is there a way to
display a calculation result in either the header or the footer?

i.e., say the sheet had grand total or $350.00, it would be neat to
have something like the header text say "Grand Total: $", then
whatever code such as, oh, [GrandTotal,G50], who knows how it would go
... so that the grand total is displayed in either header or footer.

Thx! D

 

[JP]

Good luck, hope it works out.

--JP

Kewl, so it _is_ possible.  Learn something new every day.


Will do!  Thanks.  D