Forum Discussion
Cell Formatting
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
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
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.