ExcelBanter - Sorry forgot the vb code for the header!

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Sorry forgot the vb code for the header! (https://www.excelbanter.com/excel-programming/399562-sorry-forgot-vbulletin-code-header.html)

SV[_3_]

Sorry forgot the vb code for the header!

'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

JLGWhiz

Sorry forgot the vb code for the header!

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

JLGWhiz

Sorry forgot the vb code for the header!

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

All times are GMT +1. The time now is 05:02 AM.