| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Header Font Size
I am trying to chg the header font size on a report...I tried to set the font
to the correct size in the cell and pull it in, but it did not work. I used the code below Set a = .Range("C68:C68") For Each b In a.Offset(i, 0) ss = "MYREPORT RELEASED ON: " & FormatDateTime(b, 1) Next b Sheets("My_Sheet_Name").PageSetup.RightHeader = ss 'Sheets("My_Sheet_Name").PageSetup.RightHeader.Fon tsize = 8 ??? Will not work Thanks Bret |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| don't want to have to change font in header and footer each time? | Excel Worksheet Functions | |||
| change font size on screen, but prints in old size | Excel Discussion (Misc queries) | |||
| change scaling % but font size didnt change porportionally, pls he | Excel Discussion (Misc queries) | |||
| Change all text one font size up with various font sizes used. | New Users to Excel | |||
| Change Font Color in Header???? | Excel Discussion (Misc queries) | |||
Threaded Mode
