Just ran into this problem today. Never thought autoheight would not work
for merged cells since it works for single unmerged cell. Glad I found the
solution here. Macro works fine.

"Aquarianrep" wrote:

This is working perfectly for me, however, I will need to send the
spreadsheets I created to customers. I'd like to get the macro certificate
number, but I don't know how. Any advice?

"Hpyifur" wrote:

When I merge cells and then choose the wrap text option the Autofit function
no longer works. Is there a way to get around this without manually sizing
the row each time?