Is there availability of functions in Headers/Footers?

F

FARAZ QURESHI

Can you calculate number of rows and sum of numbers therein in a column be
represented in a Header/Footer.

All means OR macros are welcome.
 
Y

yshridhar

You may calculate them is cells and make cell contents appear in header/footer
The following is the macro for that
Sub CellInFooter()
With ActiveSheet
..PageSetup.CenterHeader = .Range("A1").Value
End With
End Sub

the Value in A1 will be set to Header-Center
Change the rage according to you worksheet
With regards
Sreedhar
 
Top