+ Reply to Thread
Results 1 to 2 of 2

VBA loops with SumIfs, looking for way to decrease time to run

  1. #1
    Registered User
    Join Date
    08-21-2014
    Location
    Buena Park, CA
    MS-Off Ver
    2013
    Posts
    3

    VBA loops with SumIfs, looking for way to decrease time to run

    Greetings,

    The following code is taking 21 seconds to execute, but I would like to reduce that time. I am fairly certain that the slow down is from the SUMIFS functions, but I am not sure how to get the information through other means. Any help anyone can provide would be greatly appreciated.

    Please Login or Register  to view this content.
    Last edited by Pfaff; 09-16-2014 at 05:03 PM.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: VBA loops with SumIfs, looking for way to decrease time to run

    Can't you use standard Excel functions to perform this task. You're using Application.WorksheetFunction in your macrs there seems no reason why not. Couple them with some IF tests as necessary.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ 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. VBA For loop, optimize speed and performance
    By britzer in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-04-2014, 08:56 AM
  2. Is there any way to optimize this FOR loop?
    By lxsscott in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-23-2013, 03:50 PM
  3. Optimize for loop in order to win time
    By DamienR in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-13-2013, 11:39 PM
  4. Optimize copy/paste loop
    By aldsv in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-09-2005, 06:07 AM
  5. [SOLVED] Optimize VBA Excel 2003 NextFor loop
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-28-2005, 09:06 AM

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