autofit row problem

[joeeng]

I am finding that the autofit row/wrap text combo cell formatting does not
adjust the cell height for linked text. Is there a way to get the cells to
automatically adjust cell height when the text in the linked cell is changed?

 

[JE McGimpsey]

Call this macro by Jim Rech from a Worksheet_Change event:

http://groups-beta.google.com/group/microsoft.public.excel.misc/browse_th
read/thread/b69998ee825b7d79/dbb1bca2fd67358a?#dbb1bca2fd67358a

If you're not familiar with macros, see

http://www.mvps.org/dmcritchie/excel/getstarted.htm

and, for events:

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