Cell Formatting

[Geoffrey_1950]

Is there a way to conditional format a cell or combined cell to auto adjust the cell height when the text alignment is wrapped. i.e increase the cell height.

Thanks in advance, Geoff

[#2]

@Geoffrey_1950 try below steps:

Right click at the sheet name

Click on view Code

choose worksheet in place of general

write the code above End Sub, "Cells.EntireColumn.AutoFit"

exit the screen and try

[#3]

@Azhar_Ali_Khan1060 

Thank you for the information on the code.

I have tried the code, and the text does wrap, but when I stop entering text the row height reverts back the default height and I have to adjust the height manually to see the second row of text. 

Any further help would be appreciated.

Geoff

Happy New Year.