Results 1 to 4 of 4

vba - Wrapped text will not show up

Threaded View

  1. #1
    Registered User
    Join Date
    09-28-2012
    Location
    Marrero
    MS-Off Ver
    Excel 2007
    Posts
    7

    Post vba - Wrapped text will not show up

    Hello Experts,
    I'm a new user.
    I thought my code below would make the two line Description field show up.
    I can only manually double click on the row edge to see it appear in a larger row height.
    What is my problem please?

    Range("D12:" & "$D$" & LastRow).Select  or  rows("12:" & LastRow).Select
           
            With Selection
                .WrapText = True
                .Orientation = 0
                .AddIndent = False
                .ShrinkToFit = False
                .ReadingOrder = xlContext
                .MergeCells = False
            End With
    
            rows("12:" & LastRow).Select
    Last edited by jeffreybrown; 10-15-2012 at 12:33 AM. Reason: Please use code tags...Thanks.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1