Thread: Can't insert a String Variable of Long Date into Page Header
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dick Kusleika[_4_] Dick Kusleika[_4_] is offline
external usenet poster
  
Posts: 595
Default Can't insert a String Variable of Long Date into Page Header
Ronny Hamida wrote:

With ActiveSheet.PageSetup
.CenterHeader = _
"&""Arial,Bold""&12Employee Roster" & Chr(10) &
"&""Arial,Regular" & TheDate
End With


Ronny:

You need ..."&""Arial,Regular""" & TheDate

which includes the double quotes after Arial, Regular.

--
Dick Kusleika
MS MVP - Excel
www.dailydoseofexcel.com


Reply With QuoteReply With Quote