>Dear Sir/madam
>
>In my Excel Sheet I repeat Column A for Every page which has serial No and Caption (15 Chars) for SubTotals. But size of Column A in just 8 points or enough to Hold 3 digit Numbers.
>
>My problem is that when I print,the first page is getting print OK with complete caption but from page 2 Onward Caption is cut as Column A is repeated and its size is only 8 Points so it displays the first few char of my caption and rest is cut off.
>
>Please Advise.
>
>Note: I am using Vb6 to create my Worksheet. Solution in any form is execpted.

When you "repeat Column A for Every page", make sure the column width is set to AUTOFIT.