Forum Discussion
csoares
Jul 13, 2021Brass Contributor
Controlling row heights of long text in a cell selection
Good morning,
i wanted to increase the distance between lines of a long text that i inserted in a selection of cells grouped with "merge" and with "wrap text".
Are there any VBA commands that do what I need?
Thank you for your help
With Range("A9:I20")
.Merge
.WrapText = True
.VerticalAlignment = xlTop
.HorizontalAlignment = xlJustify
End With
Excel doesn't provide control over line spacing, but you could use
.VerticalAlignment = xlVAlignDistributed
or
.VerticalAlignment = xlVAlignJustify
3 Replies
- NikolinoDEPlatinum Contributor
- csoaresBrass Contributor72 / 5000
Resultados da tradução
thank you very much for the answers that helped me to solve the problem 🙂
Excel doesn't provide control over line spacing, but you could use
.VerticalAlignment = xlVAlignDistributed
or
.VerticalAlignment = xlVAlignJustify