SET.PRINT.TITLES macro

Defines the print titles for the sheet. Use SET.PRINT.TITLES if you want Microsoft Excel to print the titles whenever it prints any cells in a row or column that intersect the print titles area; a cell need only share the row or column with a print title for the title to be printed above or to the left of that cell.

Syntax

SET.PRINT.TITLES(titles_for_cols_ref, titles_for_rows_ref)

SET.PRINT.TITLES?(titles_for_cols_ref, titles_for_rows_ref)

Titles_for_cols_ref    is a reference to the row to be used as a title for columns.

 

Titles_for_rows_ref    is a reference to the column to be used as a title for rows.

 

Remarks

 

Related Functions

DEFINE.NAME   Defines a name on the active worksheet or macro sheet

PRINT   Prints the active sheet

SET.PRINT.AREA   Defines the print area

Return to index