Is there a way to let excel adjust the row height according to the largest merged cell in a row? To let excel search the row for merged cells and adjust the row so that the maximum needed row height is set.

I have more then one merged cells in a row and the text in all cells have to be completely visible. I have tryed your codes, but they both only "look" at the current cell.