HeaderFooter object (Excel)

Represents a single header or footer. The HeaderFooter object is a member of the HeadersFooters collection.


You can also return a single HeaderFooter object by using the HeaderFooter property with a Selection object.


You cannot add HeaderFooter objects to the HeadersFooters collection.

Use the DifferentFirstPageHeaderFooter property of the PageSetup object to specify a different first page.


The following example adds the date and time to the center header on the active worksheet.

With ActiveSheet.PageSetup 
 .CenterHeader = "&D&T" 
 .OddAndEvenPagesHeaderFooter = False 
 .DifferentFirstPageHeaderFooter = False 
 .ScaleWithDocHeaderFooter = True 
 .AlignMarginsHeaderFooter = True 
End With


See also

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.