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.
See Also