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