Assuming that the Name blockk has already been assigned to some cell:

Sub Macro1()
ActiveSheet.PageSetup.CenterHeader = Range("blockk").Value
End Sub
--
Gary''s Student - gsnu200819


"Dots" wrote:

I want to print the contents of a named range in the header of my document
when I go to print the worksheet. In the custom header options, this is not
available. Is there a way to do this and can you tell me how? Thanks!

Dots