 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / October 2007Formulae in headers or footers
Is it possible to put totals in a header or footer? I haven't seen any place that says you can or can't. If you can, then how? Thanks,  SignatureLee Coleman You need VBA code to do that. If your data is in D1:D100, this will do as an example: Right-click the Excel LOGO near the file menu, select View Code, paste this in: Private Sub Workbook_BeforePrint(Cancel As Boolean) ActiveSheet.PageSetup.RightFooter = "Total = " & Application.Sum(Range("D1:D100")) End Sub Bob Umlas Excel MVP > Is it possible to put totals in a header or footer? I haven't seen any place > that says you can or can't. If you can, then how? > Thanks, Thanks, I don't know anything about VBA but I will try the cut and paste thing. Thanks again, Lee > You need VBA code to do that. If your data is in D1:D100, this will do as > an [quoted text clipped - 14 lines] >> that says you can or can't. If you can, then how? >> Thanks,
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.