Automatically adjust row height in merged cells (code needs tweaking)

Hello Excel Experts

I have a protected worksheet where I want to automatically adjust row height of merged cells so that whenever you finish entering texts in the cell and leaving the cell, the cell's row height will adjust automatically to accommodate all the texts entered in the cell. Text wrap is turned in selected cells.

I searched the web and found a few options but this one seemed to do the trick;

Please Login or Register  to view this content.

It worked flawlessly only when the cells in a row were not merged

I kept getting this error anytime the code ran with merged cells (eg merged cell P1:T1). See image below
rowheightERROR1.png

Thanks in advance for the help!

Hi Harry,

I have not been successful when trying to adjust 'Merged Area Row Height' when Word Wrap is enabled. My efforts always resulted in a few extra blank lines at the bottom of the 'Merged Area'.

The code in the following thread works well when 'Merged Area' lines do not wrap: http://www.excelforum.com/excel-gene...ic-search.html

I will try to resurrect this when I have some time, but I can not promise anything.

Lewis

Thanks Lewis...i appreciate it. Will check out the recommended thread.

Hi Harry,

The same thread now contains an update that can also handle wrapped text in a 'Merged Area'.

See the file associated with post #5 in http://www.excelforum.com/excel-gene...ml#post4233951

Lewis