ActiveX

To specify the header content

1. If your control contains more than one sheet, specify the sheet with which you want to work by setting the Sheet property.
2. To specify the column headers' content,
   1. Set the ColHeadersAutoText property.
   2. If your sheet displays multiple column headers, specify the row to display the auto text by setting the ColHeadersAutoTextIndex property.
3. To specify the row headers' content,
   1. Set the RowHeadersAutoText property.
   2. If your sheet displays multiple row headers, specify the column to display the auto text by setting the RowHeadersAutoTextIndex property.