MrExcel.com - Your One Stop for Excel Tips & Solutions

Line feed in footer

Posted by Andy on September 11, 2001 5:26 AM

Does anyone know how to get two lines of text in a footer when using the PageSetup.LeftFooter method?

ie footer to read;

Text for frst line
Text for second line


THanks for any suggestions
Andy

Posted by Dax on September 11, 2001 5:38 AM

Use Vbcrlf like this:-
ActiveSheet.PageSetup.LeftFooter = "Line 1 of 2" & vbCrLf & "Line 2 of 2"

HTH,
Dax.