Headings Object
Headings
Multiple objects
A collection of the row and column headings for a Window object.
Using the Headings object
The following properties return a Headings collection.
The Window object's RowHeadings property.
The Window object's ColumnHeadings property.
The following example customizes the heading of column D in the active sheet in Spreadsheet1:
Spreadsheet1.ActiveWindow.ColumnHeadings(4).Caption = "1999 Sales"