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.