stretching cells

  • Thread starter Thread starter libby
  • Start date Start date
L

libby

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
 
Libby,

after you have transferred the cells, add the line:

Sheets("sheet2").columns(1).autofit

Pete
 
Back
Top