Results 1 to 14 of 14

Conflicting formatting results

Threaded View

jacob@thepenpoint Conflicting formatting results 01-23-2012, 04:19 PM
MarvinP Re: Conflicting formatting... 01-23-2012, 04:24 PM
jacob@thepenpoint Re: Conflicting formatting... 01-23-2012, 04:38 PM
MarvinP Re: Conflicting formatting... 01-23-2012, 05:02 PM
jacob@thepenpoint Re: Conflicting formatting... 01-23-2012, 05:17 PM
MarvinP Re: Conflicting formatting... 01-24-2012, 12:51 AM
jacob@thepenpoint Re: Conflicting formatting... 01-24-2012, 09:18 AM
jacob@thepenpoint Re: Conflicting formatting... 01-24-2012, 09:22 AM
jacob@thepenpoint Re: Conflicting formatting... 01-25-2012, 09:05 AM
MarvinP Re: Conflicting formatting... 01-25-2012, 12:56 PM
jacob@thepenpoint Re: Conflicting formatting... 01-25-2012, 01:55 PM
OnErrorGoto0 Re: Conflicting formatting... 01-25-2012, 12:59 PM
jacob@thepenpoint Re: Conflicting formatting... 01-25-2012, 01:57 PM
jacob@thepenpoint Re: Conflicting formatting... 01-25-2012, 04:52 PM
  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