PDA

View Full Version : Wraptext



jammer6_9
07-07-2007, 10:41 PM
Why I can not wrap a text in a cell? I have tried as well using FORMAT-CELLS-ALIGNMENT-WRAPTEXT but still the text is not wrap. VBA is also used but it's still doesnt work...


Private Sub Worksheet_Change(ByVal Target As Range)
Worksheets("Sheet1").Range("c88").WrapText = True
End Sub

jwilder1
07-08-2007, 12:07 AM
It will work if you choose Center across selection instead of merging the cells
Jim

jammer6_9
07-08-2007, 12:18 AM
Thats quite easy which I never tried. Thanks...