Peter,
You could try AutoFit. Something like this:
oWorkSheet.Rows("1:" + ALLTRIM(STR(RECCOUNT()+1))).EntireRow.AutoFit
HTH,
Daniel
>i create an xls and merge some columns and turn on wrap.
>This is filled with data from a memo field.
>I want the row height to be expanded to whateve is needed to show the whole memofield.
>if there is only one line used the default of 14 is ok
>if the field needs 34 lines a rowheit of 14*34 is more appropriate.
>
>But i cannot find a property which would expand a row like that.
>
>What could I do?
>
>Peter
Daniel