RightHeader Property
Returns or sets the right part of the header. Read/write String.
Remarks
Special format codes can be used in the header text.
Example
This example prints the filename in the upper-right corner of every page.
Worksheets("Sheet1").PageSetup.RightHeader = "&F"