how do I Change font size in footer

[jjyxk845]

I tried recording a macro of me doing it manually but that didn't point me at the right setting.

All i want to do is set the font to size to 8 for the footer.

Please help

 

[SydneyGeek]

You will find that VBA doesn't make it easy to work with headers and footers. You can do it using some fancy text strings, like this:

ActiveSheet.PageSetup.CenterHeader = _
        &""Times New Roman,Bold Italic""&11XYZ Corp."

This inserts the text XYZ Corp as bold italic, 11 pt Times New Roman in teh center header. Play with the syntax to get the result you need.
(From John Walkenbach's site)

Denis

 

[jjyxk845]

cheers for the second time today!