| Stu,
I'm no good at the programming side but I do use Excel a lot in work.
If you have a defined width for your page then you can merge a certain number of cells to get one "cell" that runs across the width of the page (Format, Cells, Alignment, merge cells).
You can then get all the text to stay visible by selecting the "wrap text" option and then selecting Format, Row, Autofit.
You should be able to record this in a macro and then copy and paste the code into your program.
Hope this helps, Chi |