Code for printing footers

  • Thread starter Thread starter Jeff Smith
  • Start date Start date
J

Jeff Smith

I want to generate a consisten footer in the centre and right. I have the
code to do this but.... when I try to get the font to 9 point I stumble. I
have copied the code from an Excel dedicated site.
My code is

"Some""Arial""&9"

I'm not sure if I'm supposed to declare something else or if I have copied a
typo.

Can anyone help?

TIA

regards

Jeff Smith
 
Put the &9 in front of the footer text

EG if you wanted the text "Some" to be in size nine then
it would be "&9Some"

Libby
 
Jeff said:
My code is

"Some""Arial""&9"
Click to expand...

To get xyz in Arial 9 point

ActiveSheet.PageSetup.LeftHeader = "&""Arial""&9xyz"

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup
 
Back
Top