XlHeaderFooter Fields

Represents the object that specifies headers and footers of a worksheet.

Name	Description
Bold	Turns bold on or off for the characters that follows.
BookName	Prints the name of the workbook.
BookPath	Prints the workbook file path.
Center	Centers the characters that follow.
Date	Prints the current date.
DoubleUnderline	Turns double underline on or off for the characters that follow.
Italic	Turns italic on or off for the characters that follow.
Left	Left aligns the characters that follow.
PageNumber	Prints the current page number.
PageTotal	Prints the total number of pages in the document.
Right	Right aligns the characters that follow.
SheetName	Prints the name of the worksheet.
Strikethrough	Turns strikethrough on or off for the characters that follow.
Subscript	Turns subscript on or off for the characters that follow.
Superscript	Turns superscript on or off for the characters that follow.
Time	Prints the current time.
Underline	Turns underline on or off for the characters that follow.