CenterFooter Property

Applies To

PageSetup object.

Description

Returns or sets the center part of the footer. Read/write String. For more information, see Formatting Codes for Headers and Footers.

Remarks

Special format codes can be used in the footer text.

See Also

CenterHeader property, LeftFooter property, LeftHeader property, RightFooter property, RightHeader property.

Example

This example prints the workbook name and page number at the bottom of each page.

Worksheets("Sheet1").PageSetup.CenterFooter = "&F page &P"