Hi
I am trying to retrieve the text that is in the center header
At the start of the program I ask the user for a sheet title
sheetTitle = InputBox("Please input title for sheet", "Title")
which I later use in the print setup
With ActiveSheet.PageSetup
.CenterHeader =...