| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: match two cells in one sheet to two cells in another and return a third cells value | Excel Worksheet Functions | |||
| compare 2 column cells and return the adjacent columns cells data of the cell | Excel Worksheet Functions | |||
| WordArt - stretching | Excel Discussion (Misc queries) | |||
| display a range of cells editible cells based on matching date | Excel Worksheet Functions | |||
| HELP..Stretching on print out | Excel Discussion (Misc queries) | |||
Linear Mode
