+ Reply to Thread
Results 1 to 28 of 28

Optimize Excel Code - Too many FOR NEXT Loops

Hybrid View

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

    Re: Optimize Excel Code - Too many FOR NEXT Loops

    Amazing code, jindon. Thank you so much. Incorporated with slight tweaks to formatting (some color changes0. Is there a way to also turn red the font in columns AM to BW? You know, the ones that are counterparts to the ones turned red in columns A to AK. Its nice to be able to scroll right and quickly locate what the values were before edits.

    Presently, all the Summarize button does is to copy the Main worksheet over to the Summary worksheet. What I need it to do is only show rows that have something red in it and the column header for that. Earlier I successfully did this with an insane amount of For Next loops. I have since deleted that because it is too slow and this was the reason for this post. Do you know how to accomplish this for rows 3 to lastrow on the Summary worksheet? Since there are so many rows on the Main worksheet, its a lot to scroll through to find the red ones that changed. That is why I want to show only the rows with some red and their headers on the Summary worksheet. Hope this makes sense. Latest workbook attached. Module password is the same - dmu123xls.

    tdsg
    Attached Files Attached Files

+ 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. [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