Excel's Help states:

"Microsoft Excel will change the row height of the range, if necessary, to
accommodate the text in the range."

Using the following, the row height does not change:
With rng
.MergeCells = True
.Value = str ' Some long string that should have to wrap
.WrapText = True
End With

Does not matter whether Value is set before/after WrapText.

Am I doing something wrong?




--
http://www.standards.com/; See Howard Kaikow's web site.