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.

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




"FARAZ QURESHI" wrote:

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.