Skip to content
Skip to breadcrumbs
Skip to header menu
Skip to action menu
Skip to quick search

Welcome to FreeSoftwareServers Confluence Wiki

Skip to end of banner Go to start of banner

Print Headers on Each Page - Excel VBA

Skip to end of metadata

Created by user-43d90 on Mar 15, 2019

Go to start of metadata

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

No labels

This site is just a Tech Blog, nothing is guaranteed!