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?

Call this macro by Jim Rech from a Worksheet_Change event:

http://groups-beta.google.com/group/...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




In article ,
joeeng wrote:

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?