+ Reply to Thread
Results 1 to 2 of 2

Column autofit stopped working

  1. #1
    Forum Contributor
    Join Date
    05-27-2014
    Location
    Belfast, Northern Ireland
    MS-Off Ver
    2007 & 2010
    Posts
    273

    Column autofit stopped working

    Hi All.

    A strange thing started happening today.

    My column autofit stopped working.

    I can manually drag the column separator and the selected columns will resize. I can use VBA to give a specific size. I can use the Home->Format->Column Width option to resize. But none of the autofit options work. Whether I double click the separator, use .columns.autofit in vba or use the Home->Format->Autofit Column Width option the cells do not autofit. The rows are autofitting just fine though.

    I get no errors with any method. It's happening on all workbooks, including new ones. I've shutdown and restarted both Excel and Windows. Nada.

    I've Googled and can't seem to find anyone describing the same problem. I'm hoping that there's a setting that's been inadvertently changed that one of you knows about.

    Please help
    Please click *Add Reputation if I've helped

  2. #2
    Forum Contributor
    Join Date
    05-27-2014
    Location
    Belfast, Northern Ireland
    MS-Off Ver
    2007 & 2010
    Posts
    273

    Re: Column autofit stopped working

    OK. I had Windows Script Hosting Object Model checked in the Available Reference Libraries dialog in the VBEditor. Unchecking this library seemed to fix the problem. However, rechecking this library doesn't reproduce the problem so I can't be sure this is where the problem was. However, the problem is gone now but feel free to add your musings as to what was happening here. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA stopped working
    By tsakta13ole in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-02-2015, 06:17 AM
  2. [SOLVED] Program was working fine, now im getting an error with "entire column.autofit"
    By emilyloz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-21-2013, 02:16 PM
  3. ocde working in one windows login but stopped working in another.
    By rama1209 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-02-2011, 08:38 AM
  4. VBA stopped working!!
    By maxthebear in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-18-2009, 09:51 PM
  5. VBA Stopped Working!
    By SamuelT in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-16-2007, 11:12 AM
  6. It's stopped working
    By mikhailia in forum Excel Programming / VBA / Macros
    Replies: 32
    Last Post: 01-22-2007, 10:12 PM
  7. VB Stopped Working
    By mptkeenan@gmail.com in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-28-2005, 09:06 AM

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