Results 1 to 13 of 13

Need to optimize code for faster processing

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-30-2009
    Location
    USA
    MS-Off Ver
    Excel 2016
    Posts
    496

    Need to optimize code for faster processing

    Hello all. I think I finally have completed the project I have been working on but since it contains code from myself as well as several other folks from the Forum, it could use an expert to optimize it so it processes faster. I added a popup that displays the total processing time of the main code block and it currently runs on the attached file in .4ish seconds. The problem is running this on my production data currently creates 544 individual sheets and each sheet is processed before adding the next sheet, so the current processing time is almost 19 minutes on a decent workstation with 4GB RAM. The sorting of the sheets and the links on the 2_Summary sheet probably don't take too long but if they can be optimized that would be great too. Thanks in advance.

    Andrew

    EDIT - I added the timer to the sorting code and it takes almost 23 minutes to sort, so that needs optimization too!
    Attached Files Attached Files
    Last edited by drewship; 01-19-2016 at 01:54 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Optimize a code
    By pezalmendra in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-06-2015, 05:31 PM
  2. Optimize code
    By DarkKnightLupo in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 02-19-2014, 08:58 AM
  3. optimize the Code needs to run faster
    By farrukh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-24-2012, 10:40 AM
  4. Optimize code
    By miso.dca in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-08-2011, 03:35 PM
  5. Streamlining VBA code to help faster processing
    By amid in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-17-2009, 05:51 AM
  6. Can anyone optimize the code? (to make it work faster)
    By olegai in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-23-2007, 07:50 AM
  7. Optimize VBA code
    By doodlebug in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-22-2007, 07:53 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