Problem setting left,center footers but not right

[MedievalMan]

I have code that sets the footer:

<code>
Worksheets(wsname).PageSetup.RightFooter = "&""Arial""&" & fontsize & "&U Effective Radius: &U" & EffRad _
& Chr(10) & "&U Piston Diameter: &U" & Pistdiam _
& Chr(10) & "&U Actual Inertia: &U" & ActInert _
& Chr(10) & "&U Actual Wheel Load: &U" & ActWheel _
& Chr(10) & "&U Rolling Radius: &U" & RollRad _
& Chr(10) & Chr(10) & "Page &P of &N"
</code>

Here's my problem: this works when setting the Right Footer, but if I change this too the Left or Center Footer, I get the following error:

"Run-time Error '1004': Unable to set the LeftFooter property of PageSetup Class"

I know I can put line breaks in the center or left footer if I make the footers manually, so what am I missing?

Thanks again.

Matt Lawson

 

[MedievalMan]

I've discovered something:

With the right and center footers,

<code>
Worksheets(wsname).PageSetup.LeftFooter = "&""Arial""&" & fontsize & "&U Brake Type: &U" & "Moretex"
</code>

If I add even 1 more character, it throws up the runtime error.

This is telling me the character limitation is 20, which it shouldn't be, as I can certainly set many more characters manually.

Thanks for any insight,

Matt Lawson

 

[MedievalMan]

Update:

It appears my problem is that the total limitation for the footers (left, center, and right combined) is 255 characters.

I doubt there is anyway to get around this?

Thanks.

-Matt