RightFooter Property Example
This example prints the page number in the lower-right corner of every page.
Worksheets("Sheet1").PageSetup.RightFooter = "&P"