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