Autofit Rows upon calculation

[GDH]

Hi all

I have created a lookup formula which returns different results based on the users choice.

My problem is that after the user changes their choice and new data appears, I have the row height from the cells previously. All cells have wrap text applied as the data being returned in sentences rather than just a few words.

I cannot see all of the data and need to use AutoFit rows to do this each time I change the lookup value.

Is there a simple macro I could use for this? Whereby the rows will be autofitted to their content after each recalculation?

Or is there an even more simple approach which I have overlooked?

Thanks