Results 1 to 5 of 5

Reduce Macro Time

Threaded View

matt9man Reduce Macro Time 01-05-2011, 12:29 PM
romperstomper Re: Help Reduce Macro Time... 01-05-2011, 12:48 PM
matt9man Re: Reduce Macro Time 01-05-2011, 02:33 PM
royUK Re: Reduce Macro Time 01-05-2011, 02:39 PM
romperstomper Re: Reduce Macro Time 01-05-2011, 03:01 PM
  1. #1
    Registered User
    Join Date
    01-05-2011
    Location
    Milwaukee,Wisconsin
    MS-Off Ver
    Excel 2003
    Posts
    7

    Reduce Macro Time

    Background:
    So I have 20 procedure macro that does the following operations:
    Clears cells from sheets, open inputs files, copys input data, creates keys by using logical keys for expected and actual, compares expected and actual results by doing vlookup off of expected key - highlights wrong cells, highlights red duplicates of actual and expected in there sheets, and then lastly finds extra actuals that are not in expected sheet and copys that key in underneath all comparisons.

    Problem: Orginally it took 2.5 hours for the Macro to compare 20,000 rows from two input files.

    Now it takes 1h20min by:

     Application.ScreenUpdating = False
    
    Application.DisplayStatusBar = False
    
    Application.Calculation = xlCalculationManual
    
    Application.EnableEvents = False
    What else can I do to reduce the time to complete 20,000 rows from 1h20min to 20 - 30 min?

    Thanks(Let me know if you need code theres like 30 pages)
    Last edited by DonkeyOte; 01-05-2011 at 12:33 PM. Reason: CODE tags at all times please

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