Printing the contents on a named range in the Header of an Excel s
 

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

Printing the contents on a named range in the Header of an Excel s
 

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