Sorry forgot the vb code for the header!

  • Thread starter Thread starter SV
  • Start date Start date
S

SV

'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
 
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.
 
Back
Top