Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help Please - Automating Row height
Please respond to newsgroup as email is bogus to prevent spam.
I am using Excel 2003. I am merging cells in one row so lines of text can be entered. (If I enter I'll use Alt-Enter for return). I have set the cell to WordWrap. However, after I test my entry the row height remains at default. Dbl clicking on it doesn't expand it. I would like my row height to automatically expand. How do I do this. Thanks in advance for any help. Respectfully, baz |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help Please - Automating Row height
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Rows.EntireRow.AutoFit End Sub "baz" wrote: Please respond to newsgroup as email is bogus to prevent spam. I am using Excel 2003. I am merging cells in one row so lines of text can be entered. (If I enter I'll use Alt-Enter for return). I have set the cell to WordWrap. However, after I test my entry the row height remains at default. Dbl clicking on it doesn't expand it. I would like my row height to automatically expand. How do I do this. Thanks in advance for any help. Respectfully, baz |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofit Row Height | Excel Discussion (Misc queries) | |||
Excel - merged cells w/wrapped text auto row height doesn't work. | Excel Discussion (Misc queries) | |||
Resizing row height to dynamically fit height of text box | Excel Discussion (Misc queries) | |||
How to Paste without changing row height | Excel Discussion (Misc queries) | |||
Row Height | Excel Discussion (Misc queries) |