I do notice that the AutoFitHeight works fine when I'm dealing with only a single row without any merged cells.
I have a situation where I have a merged cell which is the combination of cells from the same row (i.e. B2-B5). When trying to use AutoFitHeight, there is no change to the row height.
Is there anything I could do?