Is the range more than one cell? That could be the problem.
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Howard Kaikow" wrote in message
...
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.