I had this as my header
ActiveSheet.PageSetup.CenterHeader = DBID_Name + " Import"

Then I wanted to format my header and created a macro to see the code. Ended
up with this
..CenterHeader = "&""Arial,Bold""&12Collateral Import"

How do I take the formatted header, but still use the variable DBID_Name in
in place of the literal Collateral in the header? I can not get the syntax
correct.

Brenda