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.