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

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
>