ActiveSheet.PageSetup.PrintTitleRows

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

menno - 19 Apr 2005 11:07 GMT

If I use this statement with the first 4 rows as "1:4" then there is no
problem.
When I use this statement with the value "70:73" then it doesn't work at all.
What is the correct syntax for this statement ?

best regards, Menno

Reply to this Message

Paul Cundle - 19 Apr 2005 12:38 GMT

Try inserting dollar marks before each number i.e. "$70:$73". If you don't,
it seems to interpret numbers using a different base system (such as
Hexadecimal) and in the example of 70:73 the numbers just don't exist in
that system. If you try setting rows "11:13" then it will actually set
"23:25", for example.

Paul C,

Signature

> If I use this statement with the first 4 rows as "1:4" then there is
> no problem.
> When I use this statement with the value "70:73" then it doesn't work
> at all. What is the correct syntax for this statement ?
>
> best regards, Menno

Reply to this Message

Rate this thread: