Excel: Auto Adjust Row Height based on Wrapped Text Sentences

Dear Excel Experts, I tried the code below to automatically adjust the row height in merged cell from A10 to G10. For example, if my sentence is justified in 2 lines only the row height will adjust for 2 liner sentences. Then if my write ups could go longer (example: 6 lines sentences) it should also adjust based on that data. Range("A10:G10").EntireRow.AutoFit Range("A10:G10").WrapText = True However, the code doesn't seems to work. Can you help me resolve this problem? Thanks, Nhinx

This question generated 9 answers. To proceed to the answers, click here.

This thread is current as of August 04, 2017.

For more resources for Microsoft Excel