View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike Fogleman Mike Fogleman is offline
external usenet poster
 
Posts: 1,092
Default 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