Jul 13 2021 03:55 AM
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
Jul 13 2021 04:03 AM
SolutionExcel doesn't provide control over line spacing, but you could use
.VerticalAlignment = xlVAlignDistributed
or
.VerticalAlignment = xlVAlignJustify
Jul 13 2021 04:05 AM
Jul 16 2021 07:12 AM
Jul 13 2021 04:03 AM
SolutionExcel doesn't provide control over line spacing, but you could use
.VerticalAlignment = xlVAlignDistributed
or
.VerticalAlignment = xlVAlignJustify