LeftHeader Property Example
This example prints the date in the upper-left corner of every page.
Worksheets("Sheet1").PageSetup.LeftHeader = "&D"