P. S. See Formatting codes for Headers and Footers in VBA help files. Open
the VB editor, click help, type the topic in the search box.

"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