Footer Property
The Footer property returns or sets the page footer. Returns a String.
Syntax
object.Footer
object.Footer = Footer
Parameter | Type | Description |
Footer | String | required, footer text |
Example 1
This example demonstrates how to return the footer text of a worksheet.
Debug.Print WksPageSetup.Footer
Example 2
This example demonstrates how to specify a worksheet footer.
WksPageSetup.Footer= "This is a worksheet footer"
Example 3
This example demonstrates how to return the footer text of a plot window.
Debug.Print Plot.PageSetup.Footer
Example 4
This example demonstrates how to specify a plot window footer.
Plot.PageSetup.Footer= "This is a plot window footer"
Used by: WksPageSetup object, AutoPageSetup object