AutoFit Row height with cells that have a formula

[nyconfidential]

Hi all - whenever I used AutoFit Row Height on a row that is referencing data from another sheet(Lets say, Im on Sheet1 and Cell A1 is referencing Sheet2!A7), the row height does not expand to fit all of the text. Is there a simple way to get this to work? Obviously there is no problem when data is entered directly on the sheet, it only has a problem with rows what are referencing data on other sheets. Thanks!

 

[Toadstool]

Do you have it formatted to Alignment, Wrap text?

 

[nyconfidential]

Do you have it formatted to Alignment, Wrap text?

[FONT=&quot]Thanks Toad - if I go back and manually click wrap text after the text has been inserted on the other sheet, that will work, but what I would like is for the row to expand when the text is entered on the other sheet. Im guessing Id have to do this through VBA. Thanks for your help![/FONT]