Results 1 to 14 of 14

Conflicting formatting results

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-16-2010
    Location
    Memphis, TN
    MS-Off Ver
    Excel 2003, 2010
    Posts
    151

    Conflicting formatting results

    I am working on a project where I bring data in from our accounting software's database to create some inventory count sheets. In order to ensure I have the latest data, I have a macro that is supposed to update the table, and format the columns to autofit the contents.

    Sub UpdateAll()
    '
    ActiveWorkbook.RefreshAll
    Cells.Columns.AutoFit
    
    End Sub
    When it runs, it does the update, it does the autofit, and then it sets the columns of the table portion of the sheet to 8.43. I have tried using a range specifying the exact columns I needed formatted and get the same result. I don't see what I am doing wrong, and when I step through it using the debugger it finishes correctly.

    Thanks for your help!
    Last edited by jacob@thepenpoint; 01-25-2012 at 09:07 AM.
    Jacob Albers
    Excel 2003 & 2010

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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