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