| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Header with Formula
I need the code to create a custom header for only one sheet in my workbook.
I've found code on this site but cannot seem to figure out the correct syntax. Basically, I need text such as "Closed Week of " displayed followed by the previous week's date such as May 28, 2006. I have the code for the date: =(NOW()-WEEKDAY(NOW(),1))+1-7 but I do not know how to put the two together. This vba novice will appreciate any help! Thanks! Randy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need Custom format, not a formula | Excel Discussion (Misc queries) | |||
| can I use a cell's contents as part of a custom header? | Excel Discussion (Misc queries) | |||
| Data Validation - Scroll in the formula bar for a custom criteria | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Custom Header | Excel Discussion (Misc queries) | |||
Threaded Mode
