MrExcel Publishing
Your One Stop for Excel Tips & Solutions

autowrap - excel 2000


Posted by Jerry Garland on August 22, 2000 7:17 PM

My notebook has several worksheets that pull in data from one "data entry" sheet via formulas. All sheets have been formatted with autowrap. the "data entry" sheet will autowrap several lines in a cell as I am typing in my data but when I go to the dependant sheets only the first line of information is displayed in the cell. I can make these dependant cells autowrap by formatting them again but I would like them to do this automatically. any suggestions?


Posted by Celia on August 30, 0100 9:15 PM

Jerry
I have not been able to duplicate what's happening in your workbook. Can you send me a sample workbook?
Celia

Posted by Celia on August 30, 0100 10:06 PM

Have now been able to duplicate it, but don't know the answer.
In the abscence of a solution, I suppose you could have a button with a macro that auto-fits either the active sheet or all of the sheets in the workbook. For example :-

ActiveSheet.Rows.AutoFit

OR

Dim ws As Worksheet
For Each ws In Worksheets
ws.Rows.AutoFit
Next

Celia