sht.PageSetup.RightHeader = &12 dateNum

"SV" wrote:

'Create Header and Footer
headerText = "Preliminary Sales Forecast for " & drugName & "
and " & indicationName & "-" & sht.Name
sht.PageSetup.CenterHeader = headerText

dateNum = Format(Date, "mmmm d, yyyy")
sht.PageSetup.RightHeader = dateNum

Could someone help me make this font size 12 and also bold??

Thanks!
SV