Take a look at the worksheet_Change event macro:

http://cpearson.com/excel/events.htm

One way:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Target.Rows.AutoFit
End Sub

If you have merged cells, take a look he

http://google.com/groups?selm=053101...001280a%40p h
x.gbl



In article ,
lcoreyl wrote:

Is it possible to trigger a macro by changing a particular cell?

More specifically, I am running a cell height format macro, and it
would be nice if it would automatically run whenever a cell change was
made.

another solution would be if anyone knows how to make row height
autofit work on merged cells. I don't understand why it doesn't...