Consulting

Results 1 to 3 of 3

Thread: Wraptext

  1. #1
    VBAX Mentor jammer6_9's Avatar
    Joined
    Apr 2007
    Location
    Saudi Arabia
    Posts
    315
    Location

    Wraptext

    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...

    [vba]
    Private Sub Worksheet_Change(ByVal Target As Range)
    Worksheets("Sheet1").Range("c88").WrapText = True
    End Sub
    [/vba]
    T-ogether
    E-veryone
    A-chieves
    M-ore


    One who asks a question is a fool for five minutes; one who does not ask a question remains a fool forever.

  2. #2
    VBAX Regular
    Joined
    Jul 2005
    Posts
    30
    Location
    It will work if you choose Center across selection instead of merging the cells
    Jim

  3. #3
    VBAX Mentor jammer6_9's Avatar
    Joined
    Apr 2007
    Location
    Saudi Arabia
    Posts
    315
    Location
    Thats quite easy which I never tried. Thanks...
    T-ogether
    E-veryone
    A-chieves
    M-ore


    One who asks a question is a fool for five minutes; one who does not ask a question remains a fool forever.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •