how do I Change font size in footer

jjyxk845

Board Regular
Joined
Sep 8, 2006
Messages
89
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
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

SydneyGeek

MrExcel MVP
Joined
Aug 5, 2003
Messages
12,251
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:
Code:
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
 

Watch MrExcel Video

Forum statistics

Threads
1,114,402
Messages
5,547,748
Members
410,810
Latest member
thepinkbird
Top