Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Can someone point an old man in the right direction here. I am setting a
header font size and using a variable for the header text. This works just fine: Dim strAddress As String Sub Header() strAddress = "Main St" Worksheets("Sheet1").PageSetup.CenterHeader = "&24" & strAddress End Sub But when there is a number in the string, the font size becomes huge, as in this: Dim strAddress As String Sub Header() strAddress = "48 Main St" Worksheets("Sheet1").PageSetup.CenterHeader = "&24" & strAddress End Sub Is it syntax or dimmed wrong? Mike F |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Changing Font color based on font type or size | Excel Discussion (Misc queries) | |||
Change all text one font size up with various font sizes used. | New Users to Excel | |||
My tabs' font size is smaller - how do I restore default size? | Excel Discussion (Misc queries) | |||
Dropdown list for font size, font type and number formats | Excel Programming | |||
Change Header Font Size | Excel Programming |