Footer Property

Footer 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

 

Remarks

There are no header or footer options in the plot 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