Trouble with footer font


#1

I am trying to change the font for part of my footer information on the excel worksheet:



My code looks like:

ef.Worksheets(sheetIndex).PageSetup.SetFooter(1, sDisclaimer & "
&" &
ControlChars.Quote & “Arial,Bold” & ControlChars.Quote &
“&8”)



which results in a script that looks like:

“Garst Seeds &“Arial,Bold”&8”



However the text gets printed in Arial Regular 10 which is the default.



Please advise me what I need to do differently.


#2

Please change your script to:

"&"Arial,Bold"&8Garst Seeds "


#3

Thank you, that solves my problem.