Hi Dragan,
I am doing something very simillar right now.
I folowed soemwhat different aproach. I first find out where IS page break
and then I start writing sufficient number of rows up from that point.
Actually I first merge sufficient area, and then simply write memo text
to it. Word wrap should be easy to fix.
(I can send you entire automation class with this very sample if you are interested)
Pozdrav :)
>>I'm using Excel automation for all the reports. Now I got an interesting problem - I have a memo which needs to print at the bottom of the page (position not fixed, just below everything else), and needs to expand over six columns. The length of the memo is, of course, variable.
>>
>>I need to autosize this merged range vertically. Which I can't do in Excel (2003). Autosize doesn't work on merged cells, or if it does, I don't know how to get it to work. And help is of no help, of course.
>>
>>Any ideas?
>
>And, worse than that, I can't even make text to wrap at all if it's longer than 255 characters. It just shows as a line of ######################.