RightHeader Property Example
This example prints the filename in the upper-right corner of every page.
Worksheets("Sheet1").PageSetup.RightHeader = "&F"