Trouble with footer font


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 &

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.


Please change your script to:

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


Thank you, that solves my problem.