Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
changing font type in a footer
I found VBA code that would place a cell's contents into the footer:
With wkSht.PageSetup .CenterFooter = wkSht.Range("F1").Value End With I also need to change the font type to Times New Roman, Italic. I tried "&""Times New Roman,Italic" both before and after the above command on its own line and on the same line, but it either has no effect or prevents the footnote from showing up. What code do I use to change the font type along with the above code? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Footer font formating in Excel | Excel Programming | |||
Changing Font color based on font type or size | Excel Discussion (Misc queries) | |||
Different font in footer on first worksheet than the others | Excel Discussion (Misc queries) | |||
Colour of font in header/footer | New Users to Excel | |||
Dropdown list for font size, font type and number formats | Excel Programming |