how can i access the header font and size in header section of my excel via Visual basic?

You can set the font name/size by setting a string value such as

 &"Arial"&8 My Header

e.g.
ActiveWorkbook.Worksheets(1).PageSetup.LeftHeader = "&""Arial""&8 My Header"

this sets the left-hand header to "My Header" in Arial 8 point

this was helpful...

However, how do you implement a string variable?

the following is a snippet from a macro I wrote:



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 suggestions?
any help is greatly appreicated.
thanks
Nek

found the solution:

http://www.cpearson.com/excel/headfoot.htm

thanks
NM