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

D

Dots

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
 
G

Gary''s Student

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

Sub Macro1()
ActiveSheet.PageSetup.CenterHeader = Range("blockk").Value
End Sub
 
Top