thanks pete
-----Original Message-----
Libby,
after you have transferred the cells, add the line:
Sheets("sheet2").columns(1).autofit
Pete
-----Original Message-----
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
.
.
|