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