Can anyone please tell me if there is a way to automatically arrange the
height of a row to be adjusted to the text.
I have a summary sheet that is manually altered based on the validation cell
that is chosen for each situation. This changes the text that goes into the
cell.
The cell where the validation goes are merged cells and the text is wrapped.
Is there a way to automatically set the row height, for the entire sheet if
possible, by writing a macro or some other routine?
Thanks