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"