stretching cells
 

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

stretching cells
 

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
.

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
.

.