>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 ######################.