Excel Row Height 1

[deborahb]

I have text that I need to format on my spreadsheet. It needs to span multiple columns (merge) and then wrap. I don't know how many lines it will wrap to in advance. Is there a way to calculate what I should programatically set the row height to since "Wrap" doesn't change the row height for merged cells?

Thanks,

Deborah

 

[cLocKwOrkPRO]

What you want to do isn't very clear, but this is how you merge and set all the cells in the merge to wrap text.

RangeString = "C27:E34" ' you can construct this string any way you want to.


Range(RangeString).Select
With Selection
.HorizontalAlignment = xlGeneral
.VerticalAlignment = xlBottom
.WrapText = True
.Orientation = 0
.AddIndent = False
.ShrinkToFit = False
.MergeCells = True
End With


gl!
-cLocKwOrk

 

[deborahb]

I'm not sure if this will do the trick but I will check it out. Thanks. DB