Header Font size
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
|