| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automate Page Header Text
Is there a code I can apply in the page header that will read the mininum and
maximum date in a range of cells? For example: I would like the page header for some worksheets within a workbook to read "Data Report from 'minimum date here' thru 'maximum date here'. So, let's say that I had a pivot table that is refreshing the summarized data from worksheet1 that has dates in some cells. I would like to refer back to that so I can automate a date range in the page header for my pivot table. Is this possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to insert Header will full text across page | Excel Discussion (Misc queries) | |||
| Automate 'Publish as Web Page'? | Excel Discussion (Misc queries) | |||
| Excel header how to automate for new worksheets | Setting up and Configuration of Excel | |||
| Omit header from first page without embedding header in code | Excel Worksheet Functions | |||
| Without using Header/Footer, how would I anchor text on a page? | Excel Discussion (Misc queries) | |||
Threaded Mode
