Hi
I have a workbook with two sheets.
Sheet1 has a range of cells A1:A6 which the user inputs
information into.

When they click a button on the sheet, the information in
each of cells in the range on sheet1 is copied into one
cell (A1) on sheet2.

I've managed to get a space between each of the cells by
using Chr(10), but my question is, how do I get the cell
on Sheet2 to display all the text in it - I'd like it to
keep expanding and not to close up when it loses focus.

Many thanks