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