Results 1 to 18 of 18

Excel 2007 : Macro - loop slows down

Threaded View

  1. #1
    Registered User
    Join Date
    05-19-2010
    Location
    San Diego, California
    MS-Off Ver
    Excel 2007
    Posts
    7

    Macro - loop slows down

    I created a macro that runs an iterative process. The macro basically makes some adjustments to some data and copies the data to a blank row. Then, the macro does the same thing over and over.

    There are 13000 rows the macro cycles through and I noticed around row 4000, the macro's speed essentially comes to a stop. I also noticed at row 4000 my computer usage (via the task manager) jumps from 60% to 90%.

    I assume it is not a coding issue since the macro runs for awhile, but then hits a wall in the middle of the iterative portion.

    Does anyone have ideas as to what is going on?
    Last edited by IALTO; 05-21-2010 at 10:25 AM.

Thread Information

Users Browsing this Thread

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

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