this was helpful...
However, how do you implement a string variable?
the following is a snippet from a macro I wrote:
Application.Worksheets("sheet1").PageSetup.LeftHeader = _
"&""Arial,bold""&15""& " & Worksheets("sheet2").Range("A1").Value
this seems to work (correct font and size) except that whatever the ("A1").value is it will print that preceded by a quotation mark (ie... "myvalue )
I have tried various combos within the syntax, but this is as close as I can get. I should note that the value mentioned is a number, just in case that may mean something.
any help is greatly appreicated.