SOLVED

Controlling row heights of long text in a cell selection

Brass Contributor

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

 

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

3 Replies
best response confirmed by csoares (Brass Contributor)
Solution

@csoares 

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

 

.VerticalAlignment = xlVAlignDistributed

 

or

 

.VerticalAlignment = xlVAlignJustify

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

Accepted Solutions
best response confirmed by csoares (Brass Contributor)
Solution

@csoares 

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

 

.VerticalAlignment = xlVAlignDistributed

 

or

 

.VerticalAlignment = xlVAlignJustify

View solution in original post