+ Reply to Thread
Results 1 to 3 of 3

Autofit Columns based on largest amount of characters

  1. #1
    Forum Contributor dagindi's Avatar
    Join Date
    06-02-2008
    Location
    New York, NY
    MS-Off Ver
    Excel 2007 & 2010
    Posts
    295

    Autofit Columns based on largest amount of characters

    I found the following code which does exactly what its programed to do:

    Please Login or Register  to view this content.
    The problem is if I enter 15 characters and then enter 10 characters in the same column (different cell), the code auto-fits the entire column to the last entered value even though it has less characters then any other entry.

    Can this code be edited to auto-fit to the cell in the column with the most characters?

  2. #2
    Forum Expert
    Join Date
    09-27-2011
    Location
    Poland
    MS-Off Ver
    Excel 2007
    Posts
    1,312

    Re: Autofit Columns based on largest amount of characters

    try this
    Please Login or Register  to view this content.
    Regards

    tom1977

    If You are satisfied with my solution click the small star icon on the left to say thanks.

  3. #3
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Autofit Columns based on largest amount of characters

    instead of autofit based on target, autofit based on column

    Please Login or Register  to view this content.

+ 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