Header Property

The Header property returns or sets the page header text. Returns a String.

Syntax

object.Header

object.Header = Header

 

Parameter Type Description
Header String required, header text

 

Example 1

This example demonstrates how to return the header text of a worksheet.

Debug.Print WksPageSetup.Header

 

Example 2

This example shows how to set the text for a plot window header.

Plot.PageSetup.Header = "This is my header"

 

Used by: WksPageSetup object, AutoPageSetup object