Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jun 2009
    Location
    Hemet CA
    Posts
    310
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I知 using Excel 2007; I知 trying to AutoFit the height within a row that has merge cells and wrap text. What I知 hoping to achieve is when you enter text within a cell and it goes beyond the size of the formatted cell it will expand downward, just like a paragraph within a table (Word) and of course without disturbing other cells above or below is this possible.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Check out the thread and posts in
    http://lounge.windowssecrets.com/ind...dpost&p=270876

    Steve

  3. #3
    3 Star Lounger
    Join Date
    Jun 2009
    Location
    Hemet CA
    Posts
    310
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Steve
    Thank You so much
    It worked better than I hoped
    I was also able to select multible cells just by adding to the Range that I wanted to AutoFit
    Code:
    Private Sub Worksheet_Change(ByVal Target As Excel.Range)
    'Use the Range to select desired cells
        If Not Intersect(Target, Range("B2,D5,I7,K3")) Is Nothing Then
            Target.Select
            AutoFitMergedCellRowHeight
        End If
    End Sub

Posting Permissions

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