VBA Code to Print a Variable as part of CenterHeader Problem

[gvlral]

Under PageSetup

..CenterHeader = "&""Arial,Bold""&12CW" + CalWk

I am getting a Type Mismatch when running this line of code.

A earlier line of code,
CalWk = Range("B1").Value
picks up the calendar week number from the worksheet.
When the line tries to run CalWk = 3

Any Help would be appreciated,
(e-mail address removed)

 

[Tom Ogilvy]

"&""Arial,Bold""&12CW" & CalWk

use ampersand instead of +

 

[Bob Phillips]

Try

..CenterHeader = "&""Arial,Bold""&12CW" & CalWk

--

HTH

RP
(remove nothere from the email address if mailing direct)