How to AutoFit Row Height Merge Cells?

Please, help me to AutoFit Row Height the contents on merge cells with wrap text. On the unmerge cell AutoFit Row Height works perfectly.

The following code adds up the column widths of the individually merged cells, unmerges the cell, resets the width of the first cell in the range to the combined width, autofits the row height of the single cell and remerges the cell.

The way I suggest you use this is to make up a macro like Test() and map it to a control key. Then you can select the cell and click on the control combination and the cell will be formatted.

Please Login or Register  to view this content.

@ dflak, thanks a lot it works well. but please, help me to apply the change automatically without run macro sub (test) manually. And how to apply multiple selections?

I don't think I can make it automatic. To make it apply to multiple selections, try using the following code.

Please Login or Register  to view this content.