PrintRowAndColumnHeader Property

 

PrintRowAndColumnHeader returns or sets whether row and column headers are printed. It has a Boolean value. If this value is set to 'True', the column letters and row numbers of the worksheet will be printed. If this value is set to 'False', the row and column headers will not be printed.

Syntax

object.PrintRowAndColumnHeader

object. PrintRowAndColumnHeader = Headers

Parameter	Type	Description
Headers	Boolean	required

Example 1

This example returns whether or not row and column headers are printed.

Debug.Print WksPageSetup.PrintRowAndColumnHeader

Example 2

This example prints the row and column headers.

WksPageSetup.PrintRowAndColumnHeader = True

Used by: WksPageSetup object