Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using named range value during Workbook_BeforePrint event
I have the following procedu
Sub Workbook_BeforePrint(Cancel As Boolean) With ActiveSheet.PageSetup .LeftHeader = "" .CenterHeader = _ "&""Arial,Bold""&12 NNN TITLE&""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 End Sub I'd like to add the range name "TEST" in where it has NNN in the ..CenterHeader. What do I need to change? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using named range value during Workbook_BeforePrint event
.CenterHeader = _
"&""Arial,Bold""&12 " Range("TEST").Value & " TITLE&""Arial,Regular""&10" & _ Chr(10) & "Last date saved: " & _ Format(ThisWorkbook.BuiltinDocumentProperties("las t save time").Value, "dd-mmm-yyyy") -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Barb Reinhardt" wrote in message ... I have the following procedu Sub Workbook_BeforePrint(Cancel As Boolean) With ActiveSheet.PageSetup .LeftHeader = "" .CenterHeader = _ "&""Arial,Bold""&12 NNN TITLE&""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 End Sub I'd like to add the range name "TEST" in where it has NNN in the .CenterHeader. What do I need to change? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Named Range in Worksheet_Change event | Excel Programming | |||
inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
If any cell in named range = 8 then shade named range | Excel Programming | |||
Change event triggered by a named range | Excel Programming | |||
Change Event on a named range | Excel Programming |