Print titles must be contiguous...

[Roderick Prince]

Using XlsIO ver 7.303.0.20 and code like:
sheet.PageSetup.PrintTitleRows = "$A$1:$IV$5";

Leads to an Error in Excel 2007 of:
Print titles must be contiguous and complete rows or columns.

Anyone else experiencing this and know of a way to correct it?

[Geetha M]

Hi Roderick,

I was able to see the problem. This occurs as both Rows and Columns are used to Print Title. As mentioned in the forum linked below, please use Rows to print in the top and Columns to print in the left:

Print

sheet.PageSetup.PrintTitleRows = "$1:$5";
sheet.PageSetup.PrintTitleColumns = "$A:$IV";

Please try this and let me know if you have any questions.

Regards,
Geetha