Skip to content

Line Break in Excel Header / Footer via Macro

Using VBA, add line break to header or footer with Chr(13).

E.g.

ActiveSheet.PageSetup.LeftFooter = "Foo bar" & Chr(13) & "Another line"

Post a comment — Trackback URI RSS 2.0 feed for these comments This entry (permalink) was posted on Monday, January 11, 2010, at 10:52 am by Jussi. Filed in Software and tagged , , .

Post a Comment

Your email is never published nor shared. Required fields are marked *
*
*