In Excel, how to autofit for results of a formula
 

I am using a formula to designate a multi-line block of text from a cell in
another worksheet, and would like to autofit the destination cell. It
autofits to the formula rather than to the resulting text. Is there a way to
do this?