Merge cell with WrapText=true

[David Pereira]

Hello.
I am trying:
----------------------
|         |          |
----------------------
| This is a long text|
| with WrapText=true |
----------------------

but not work.

In VB code:
ERROR!!
    Range("D16:E16").Select
    With Selection
        .HorizontalAlignment = xlGeneral
        .VerticalAlignment = xlBottom
        .WrapText = True
        .Orientation = 0
        .AddIndent = False
        .ShrinkToFit = False
        .MergeCells = True                      <----------------
    End With

OK!!
    Range("D6:E6").Select
    With Selection
        .HorizontalAlignment = xlCenter
        .VerticalAlignment = xlBottom
        .WrapText = True
        .Orientation = 0
        .AddIndent = False
        .ShrinkToFit = False
        .MergeCells = False                     <----------------
    End With
    Selection.Merge                     <----------------

How can I do it with HSSF?

Thanks

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]