Using named range value during Workbook_BeforePrint event

[Barb Reinhardt]

I have the following procedure:

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("last 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

 

[Bob Phillips]

.CenterHeader = _
"&""Arial,Bold""&12 " Range("TEST").Value & "
TITLE&""Arial,Regular""&10" & _
Chr(10) & "Last date saved: " & _
Format(ThisWorkbook.BuiltinDocumentProperties("last save
time").Value, "dd-mmm-yyyy")


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)