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
-----Original Message-----
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


.

Jeff Smith wrote:
My code is

"Some""Arial""&9"


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

Thank you very much. All working well now. Appreciated.

regards

Jeff Smith

"Bill Manville" wrote in message
...
Jeff Smith wrote:
My code is

"Some""Arial""&9"


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