View Single Post
  #3 (permalink)  
Old March 26th, 2007, 09:53 PM
NekMoth NekMoth is offline
Registered User
Join Date: Mar 2007
Location: Portland, Oregon, .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts

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

Reply With Quote