Skip to content

Tag Archives: VBA

Cell Reference to Excel Header / Footer [Only VBA will do]

12-Jan-10

The only way: use a VBA macro. E.g. ActiveSheet.PageSetup.LeftFooter = "Check: " &  Sheets(SETTINGS_SHEET_NAME).Range("F4").Value

Line Break in Excel Header / Footer via Macro

11-Jan-10

Using VBA, add line break to header or footer with Chr(13). E.g. ActiveSheet.PageSetup.LeftFooter = "Foo bar" & Chr(13) & "Another line"