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; header text

 

Remarks

There are no header or footer options in the map 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