WrapText Property
 

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.