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

  • Thread starter Thread starter jana.phillips
  • Start date Start date
J

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.
 
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
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
 
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.
 
Back
Top