I'm trying to programmatically insert header and footer information in Excel. If I have the following input variables identified, what would be the correct syntex to use?
myFont, myFontSize, myHeaderFooterText
I've tried the following and it did not work.
BuildString = Chr(34) & "&" & Chr(34) & Chr(34) & myFont & " Chr(34) & Chr(34) & "&"_
& myFontSize & myHeaderFooterText & Chr(34)
wksht.PageSetup.RightFooter = BuildString
Can someone help?