| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How do I use a function in a footer?
Is it possible to use a function in a header or footer? I'd like to be able
to include the date the file was last saved. Thanks! |
|
#2
|
|||
|
|||
|
You can't put a function or formula in a header or footer. In
your case, you can use VBA code to set the Left/Center/Right Header/Footer to the last save date. ActiveSheet.PageSetup.CenterHeader = _ ThisWorkbook.BuiltinDocumentProperties("Last Save Time") -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "KHNorton" wrote in message ... Is it possible to use a function in a header or footer? I'd like to be able to include the date the file was last saved. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to list unique values | Excel Worksheet Functions | |||
| I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
| Find a Function to use accross different worksheets | Excel Worksheet Functions | |||
| change function variable prompts?? | Excel Worksheet Functions | |||
| Counting Function Dilemma | Excel Worksheet Functions | |||
Hybrid Mode
