Results 1 to 28 of 28

Optimize Excel Code - Too many FOR NEXT Loops

Threaded View

  1. #1
    Registered User
    Join Date
    06-10-2016
    Location
    United States
    MS-Off Ver
    Microsoft 365 Enterprise
    Posts
    63

    Optimize Excel Code - Too many FOR NEXT Loops

    Hi All, Attached is a macro-enabled workbook with a lot of For Next Loops. Run speed is mostly bearable except for the Summarize button which calls a Summarize Sub. Its actually 3 Subs strung together with Two Calls between them -Summarize, Summarize2, Summarize3. The gist of this application is that the user runs through the buttons on the Main worksheet in order from left to right. It all starts with Importing a Before and After html file, then comparing them for differences. I would supply the two files, but we can't upload that file type apparently.

    Anyway, I'm a novice with VBA. Love it and I certainly see its huge potential, but I mostly have to steal code (or beg help) and modify to fit my situation. Could someone with more experience give me any tips to speed up the code? Again, its mainly the Summarize Subs with SOOOOO many For Next loops. Is there a better way? Password for the vba module is dmu123xls.

    Thank you, tdsg
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Improve code performance to Optimize Loops
    By MusicMan in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-19-2021, 01:07 PM
  2. How to Optimize This Code?
    By therealdees in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 03-20-2021, 02:40 AM
  3. Trying to optimize VBA code for Excel 365
    By Groovicles in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-19-2019, 01:58 AM
  4. [SOLVED] Optimize my VBA code
    By modytrane in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-07-2019, 11:25 AM
  5. [SOLVED] optimize macro - cutting down loops and autofill
    By gwsampso in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-04-2012, 12:56 AM
  6. Optimize code
    By miso.dca in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-08-2011, 03:35 PM
  7. if else loops excel vba code required
    By razwan1978 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-09-2009, 03:10 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