PageSetup.PrintTitleColumns property (Excel)
Returns or sets the columns that contain the cells to be repeated on the left side of each page, as a String in A1-style notation in the language of the macro. Read/write String.
expression A variable that represents a PageSetup object.
If you specify only part of a column or columns, Microsoft Excel expands the range to full columns.
Set this property to False or to the empty string ("") to turn off title columns.
This property applies only to worksheet pages.
This example defines row three as the title row, and it defines columns one through three as the title columns.
Worksheets("Sheet1").Activate ActiveSheet.PageSetup.PrintTitleRows = ActiveSheet.Rows(3).Address ActiveSheet.PageSetup.PrintTitleColumns = _ ActiveSheet.Columns("A:C").Address
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.