About Us

SV[_3_]

'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

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

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
I forgot my password, how do I open a sheet if I forgot the pass	Hector Solorzano	Excel Worksheet Functions	4	February 20th 13 05:08 AM
Omit header from first page without embedding header in code	ibvalentine	Excel Worksheet Functions	6	August 28th 07 05:10 AM
Forgot the Code	Duncan_J	Excel Programming	1	February 2nd 06 10:01 PM
Header code	Bdavis[_2_]	Excel Programming	6	November 4th 04 05:07 AM
Header code	BDavis	Excel Programming	0	November 3rd 04 09:10 PM

Menu

About Us