Custom Worksheet Header

[Guest]

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

 

[PaulD]

<snip>
: 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
:

try
..CenterHeader = "&""Arial,Bold""&12" & DBID_Name & " Import"
Paul D