H
Howard Kaikow
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?
"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?