The Footer property returns or sets the page footer text for the worksheet. Returns a string.
Syntax
object.Footer
object.Footer = Footer
|
Parameter |
Type |
Description |
|
Footer |
String |
required; footer text |
Remarks
There are no header or footer options in the map window.
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"
Used by: WksPageSetup object