PrintTitleRows

[James Webb]

I can''t seem to be able to specify an appropriate syntax of text to the PrintTitleRows PageSetup property.

I either get errors when assigning the property in code. I''ve tried several things, such as:

sht.PageSetup.PrintTitleRows = 1;
sht.PageSetup.PrintTitleRows = "$1:$1";
sht.PageSetup.PrintTitleRows = sht.Rows[1].Address;
, etc

and IF one of those ''takes'', I get a "print titles must be contiguous..." error in excel when I try to print preview my file.

As per usual, the documentation is lacking, and I can''t seem to find any sample code to go by to make this work.

Can you please provide me with some guidance?

[Administrator]

Hi James,

Here is the usage code snippet

1) PrintTitleRows:

//Print Rows 1 to 3
sheet.PageSetup.PrintTitleRows = $A$1:$IV$3

2) PrintTitleColumns:

//Print Columns 1 to 3
sheet.PageSetup.PrintTitleColumns = $A$1:$C$65536

Sorry for the inconvenience. Please let me know if you have any questions. Thanks.

Best regards,

Stephen.

>I can''t seem to be able to specify an appropriate syntax of text to the PrintTitleRows PageSetup property.
>
>I either get errors when assigning the property in code. I''ve tried several things, such as:
>
>sht.PageSetup.PrintTitleRows = 1;
>sht.PageSetup.PrintTitleRows = "$1:$1";
>sht.PageSetup.PrintTitleRows = sht.Rows[1].Address;
>, etc
>
>and IF one of those ''takes'', I get a "print titles must be contiguous..." error in excel when I try to print preview my file.
>
>As per usual, the documentation is lacking, and I can''t seem to find any sample code to go by to make this work.
>
>Can you please provide me with some guidance?