How do I add a second line in a footer using RightFooter?
--
Peace

Press ENTER after the first part

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Montana" <(E-Mail Removed)> wrote in message news:1BE7E17E-65E7-49E3-B336-(E-Mail Removed)...
| How do I add a second line in a footer using RightFooter?
| --
| Peace

You can use: & vbCrLf

"Montana" wrote:

> How do I add a second line in a footer using RightFooter?
> --
> Peace

Sorry, forgot you want a VBA solution (which you have now)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Niek Otten" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
| Press ENTER after the first part
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "Montana" <(E-Mail Removed)> wrote in message news:1BE7E17E-65E7-49E3-B336-(E-Mail Removed)...
|| How do I add a second line in a footer using RightFooter?
|| --
|| Peace
|
|

JLGWhiz: Where does this code co in the line to be typed? e.g.,
..CenterFooter = "xxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxxxx"
--
Peace


"JLGWhiz" wrote:

> You can use: & vbCrLf
>
> "Montana" wrote:
>
> > How do I add a second line in a footer using RightFooter?
> > --
> > Peace

It goes where you want the line feed to occur:

Sheets(1).PageSetup.CenterFooter = "&"Arial" &B &12 &"mytext" _
& vbCrLf & "more mytext" & vbCrLf & "more mytext"

Would give you three lines of text in Bold Arial type.

"Montana" wrote:

> JLGWhiz: Where does this code co in the line to be typed? e.g.,
> .CenterFooter = "xxxxxxxxxxxxxxxxxxxx
> xxxxxxxxxxxxxxxxxxxxxxx"
> --
> Peace
>
>
> "JLGWhiz" wrote:
>
> > You can use: & vbCrLf
> >
> > "Montana" wrote:
> >
> > > How do I add a second line in a footer using RightFooter?
> > > --
> > > Peace