Row Height does not update on wrapped text until I reopen file

[jana.phillips]

In my worksheet which uses the LOOKUP function, the cell
is formatted with wrap text on. When the lookup displays
the answer, the row height does not change. When I close
the file and reopen it, the row height has adjusted. This
occurs in Excel 2000, XP, and 2003.

 

[Anne Troy]

Do you have manual calculation turned ON? What happens if you turn it off
and go back to automatic calculation?
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Com.Piersontech@Dreamboat
(Reverse it!)
Web: www.TheOfficeExperts.com
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->

 

[Dave Peterson]

I've never seen excel adjust rowheight when a formula evaluates to something
else. I think that this is just the way excel works. For the most part,
formulas return values to cells--they don't change other stuff--like other cells
or even rowheights.

(It's interesting that reopening the workbook will reset the rowheight.)

But maybe you could use a worksheet event to autofit the rowheight:

Right click on the worksheet tab that should have this behavior. Select view
code and paste this in:

Option Explicit
Private Sub Worksheet_Calculate()
Me.Rows.AutoFit
End Sub


When xl recalcs that sheet, the rowheight will be adjusted.