VBA Code to Print a Variable as part of CenterHeader Problem
 

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,

VBA Code to Print a Variable as part of CenterHeader Problem
 

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

use ampersand instead of +

--
Regards,
Tom Ogilvy


"gvlral" wrote in message
...
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,

VBA Code to Print a Variable as part of CenterHeader Problem
 

Try

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

--

HTH

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


"gvlral" wrote in message
...
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,