Print Headers on Each Page - Excel VBA

Row 1 as Headers

With ActiveSheet.PageSetup
     .PrintTitleRows = "$1:$1"
     .PrintTitleColumns = ""
End With

Row 1 Cells 1:4 as Row Headers

With ActiveSheet.PageSetup
     .PrintTitleRows = "A1:B4"
     .PrintTitleColumns = ""
End With

Page tree