Using Excel 2000. How do you align text to the left in the Right Footer.
I've tried using & L but can't seem to make it work. Below is the code as
written so far.

Joel Mills

Sub MultiRight()
With ActiveSheet.PageSetup
Dim RF1 As String
Dim RF2 As String
Dim RF3 As String
Dim RF4 As String
RF1 = InputBox("Enter 1st Line of Footer")
RF2 = InputBox("Enter 2nd Line of Footer")
RF3 = InputBox("Enter 3rd Line of Footer")
RF4 = InputBox("Enter 4th Line of Footer")
.RightFooter = RF1 & Chr(10) & L & RF2 & Chr(10) & L _
& RF3 & Chr(10) & L & RF4 & Chr(10) & L
End With
End Sub