How to set the footer size using VBA

Isadora · #1 08-17-2013, 10:39 AM

Hello,

I am working on a macro that adds the footer to my Excel spreadsheet.
I have the letterhead in Word and the footer is in Arial Black, bold, size 10, in a particular shade of green.

How should I edit the following code, so that the footer is inputed in font 10? At the moment, the footer is inserted as Arial 11 (I guess it's Excel default font size).

Quote:

With ActiveSheet.PageSetup
.LeftHeader = ""
.CenterHeader = ""
.RightHeader = ""
.LeftFooter = ""
.CenterFooter = _
"&""Arial Black,Normale""&K339966MY COMPANY Ltd" & Chr(10) & "VAT registration No. GB 111 1111 11" & Chr(10) & "Registered in England and Wales No. 1111111"
.RightFooter = ""

Isadora · #2 08-20-2013, 05:50 AM

I figured this out alone.

Here's the solution to set the font size to 10 (change that number to get the font size you want):

Code:

.CenterFooter = _
"&""Arial Black,Normale""&10&K339966MY COMPANY Ltd" & Chr(10) & "VAT registration No. GB 111 1111 11" & Chr(10) & "Registered in England and Wales No. 1111111"

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Footer, text size .doc vs .docx problem	KenZu	Word	4	06-12-2013 10:38 AM
Footer - more then one footer (auto fill text in slides)	noodle	PowerPoint	0	03-31-2013 04:50 AM
how change size font to inches size	kkepo	Word	4	08-28-2012 08:53 PM
Cursor size varies with font size	r_lewis@fuse.net	Word	0	07-20-2011 06:11 PM
Changing size of footer	izzyf	Word	2	03-23-2009 12:19 PM