I want to set the row height for a row containing merged cells with long text that wraps.

Autoheight doesn't work.

The only way I can think to do it is to demerge the cells, select the range, format for centre across selection, autofit. At this point I would note the row height and then merge the cells and set the height to that noted.

I need the cells merged to use justified alignment.

If you can think of a better way I would appreciate.

Kaval