+ Reply to Thread
Results 1 to 2 of 2

Adjust the size of cells automatically

  1. #1
    Dajana
    Guest

    Adjust the size of cells automatically

    I need to adjust the size of cells automatically. I am copying information
    from one sheet to another automatically and depending on what amount of
    information is copied the size of these cells has to adjust automatically or
    at least increase to accomodate all text. Is there any way to do this?

    Thanks

  2. #2
    Ken Johnson
    Guest

    Re: Adjust the size of cells automatically

    Dajana,
    This worked for me:
    Paste this code into ThisWorkbook code module in the VBA Editor

    Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As
    Range)
    Target.Columns.AutoFit
    End Sub

    Ken Johnson


+ Reply to Thread

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