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")
          .WrapText = True
          .VerticalAlignment = xlTop
          .HorizontalAlignment = xlJustify
End With


Captura de ecrã 2021-07-13 102018.jpg

3 Replies
best response confirmed by csoares (Contributor)


Excel doesn't provide control over line spacing, but you could use


.VerticalAlignment = xlVAlignDistributed




.VerticalAlignment = xlVAlignJustify

72 / 5000
Resultados da tradução
thank you very much for the answers that helped me to solve the problem