Is there availability of functions in Headers/Footers?

  • Thread starter Thread starter FARAZ QURESHI
  • Start date Start date
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Disabling the "&[Time]" or "&[T]" in Excel headers and footers 2
Change Header & Footer Info w/ Worksheet Option Buttons 1
Headers & Footers _auto update info from a cell in the worksheet 4
Header and Footer 5
headers footers 3
Dates-Automatically entered in cells 7
Protecting Headers and Footers!! 2
Header and Footer margins 1

Back
Top