Not sure what you mean, but does this work ?

Range("A1").Rows.AutoFit

NickHK

"Troubled User" wrote in message
...
I need to automatically adjust the height of the row attached to text box,
based on the length or amount of data in the text box. Any ideas?