Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying something within a range name in an Excel Header
I have the following code to modify the header for the worksheet.
Sub Workbook_BeforePrint(Cancel As Boolean) Application.ScreenUpdating = False With ActiveSheet.PageSetup .LeftHeader = "" .CenterHeader = _ "&""Arial,Bold""&12TITLE &""Arial,Regular""&10" _ & Chr(10) & "Last date saved: " & Format(ThisWorkbook.BuiltinDocumentProperties("las t save time").Value, "dd-mmm-yyyy") .RightHeader = "" .LeftFooter = "" .CenterFooter = "" & Chr(10) & "&P of &N" .RightFooter = "" End With Application.ScreenUpdating = True End Sub Where I have TITLE, I want to display the value of the range name "TEST" and then follow it with TITLE. What do I need to change to get this to work?' Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying range value when range name is concatenated | Excel Discussion (Misc queries) | |||
Automatically display filter range in report header in Excel | Excel Worksheet Functions | |||
I displaying a range in Time within a cell in Excel. | Excel Discussion (Misc queries) | |||
Excel-Header-My Company Name won't work in Header (AT&T) & Time | Excel Discussion (Misc queries) | |||
displaying data from a range | Excel Programming |