RightFooter Property
Returns or sets the right part of the footer. Read/write String.
Remarks
Special format codes can be used in the footer text.
Example
This example prints the page number in the lower-right corner of every page.
Worksheets("Sheet1").PageSetup.RightFooter = "&P"