Thread: VBA Code to Print a Variable as part of CenterHeader Problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
gvlral gvlral is offline
external usenet poster
  
Posts: 3
Default 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,



Reply With QuoteReply With Quote