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
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