how to trigger macro or force autofit

[lcoreyl]

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...

 

[lcoreyl]

sorry, found another thread already dealing with this...

http://www.excelforum.com/showthread.php?s=&threadid=156446

 

[J.E. McGimpsey]

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 here:

http://google.com/groups?selm=053101c33e8f$3e89ce90$a001280a@ph
x.gbl

 

[Tom Ogilvy]

Use the change event to run your macro.

Right click on the worksheet tab and select view code.

in the left dropdown select Worksheet and in the Right, Change, (not
SelectionChange). This will put in the declaration for the change event and
you can call you macro here. The target arguments specify the Cell or
cells that were edited and triggered the event.