Forum Discussion
Is it possible (without coding) to automatically modify the row height in Excel?
- Jul 12, 2021
If apply Wrap text is shall work
As Mr. Baklan already informed you, with wrap text you can manage the line break.
Here is additional information:
Microsoft Link: Wrap text in a cell
VBA:
Sub wrap()
With Range("B9")
.Value = Replace(.Value, ";", vbLf)
.Value = Replace(.Value, vbLf & " ", vbLf)
.EntireRow.AutoFit
End With
End Sub
In composite cells it is not possible to have the row height or width determined automatically.
If you want to wrap text in merged cells, you have to do it differently.
If so, please let me know to show the way.
Nikolino
I know I don't know anything (Socrates)
- aquigley1Oct 23, 2024Brass ContributorHow do you do it differently for merged cells?
- HansVogelaarOct 23, 2024MVP
You have asked the same question in four different discussions. That leads to confusion and duplication.
- aquigley1Oct 23, 2024Brass ContributorYet still no answer...
- GlenRowsonJul 13, 2021Copper Contributor
NikolinoDE - Many thanks for getting back to me with this advice - I really appreciate it.
- NikolinoDEJul 13, 2021Gold Contributor
I am pleased that you have received the proposed solution from MR. Baklan helped.
I added only the steps.
I wish you continued success with Excel.