| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to add a forumla calculation to a footer
I have the following code. I need it to add the result of the formula to the
footer is there a different way I can do this because what I'm doing now doesn't show up in the footer. Private Sub Workbook_BeforePrint(Cancel As Boolean) ActiveSheet.PageSetup.LeftFooter = Date & " - " & Round((Date - 34448) / 7, 0) + 1 End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Most Used Name Forumla | Excel Worksheet Functions | |||
| How can I use a calculation in a footer? (eg (=10+1)!!) | Excel Discussion (Misc queries) | |||
| Forumla | Excel Discussion (Misc queries) | |||
| IF Forumla help | Excel Discussion (Misc queries) | |||
| Forumla calculation | Excel Discussion (Misc queries) | |||
Threaded Mode
