Header Property

Header returns or sets the page header text in the worksheet. Returns a string.

Syntax

object.Header

object. Header = Header

Parameter	Type	Description
Header	String	required

Remarks

There are no header or footer options in the plot window.

Example 1

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

Debug.Print WksPageSetup.Header

Example 2

This example demonstrates how to specify a worksheet header.

WksPageSetup.Header = "This is a worksheet header"

Used by: WksPageSetup object