Hi I'm creating a workbook to generate invoices, with an "input" worksheet for people to enter data and an "invoice" worksheet which will be protected so users cannot edit it but is based on the input worksheet and will be used to print the invoice. The input worksheet will use concatenate and char(10) to produce multi line information in each row which will have a varying number of lines. The invoice worksheet will display the results from these formulae. Depending on the invoice to be produced the number of rows used will vary. I want the invoice to display the rows with heights adjusted to accomodate the number of lines produced and to reduce the height of rows to zero if the row has no information displayed. With a macro I can hide the rows with no information but have not found a way to automatically adjust the heights of the other rows. Any suggestions would be appreciated. Thanks Cliff

Hi, How about using Text boxes to hold text. You can link the contents of a text box to a cell or cells. Click on a text box frame and enter a cell reference in the formula bar. e.g., Text in Cell A1 Formula for text box: =A1 Text boxes will wrap text for you and you shouldn't have to worry about hiding rows or adding Char(10) for new lines. Text boxes can also be set to autosize. Right click text box and select Format Text Box, then alignment Tab. Regards

Thanks Humar, text boxes seem to be a good solution, they are one of those features I'd never used before. Cliff