Assign the PageSetup.CenterHeader property for the worksheet to your
variable.

--
Rick (MVP - Excel)


"Ken Hudson" wrote in message
...
As part of a macro I am opening an existing workbook. That WB has a center
header in the print set up. How can I pull that center header string into
the
macro and assign it to a variable?

Dim SHeader as String
Sub GetHeader
Workbooks.Open "Test.xls"
sHeader= what?
...........
........
End Sub
--
Ken Hudson