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.