Results 1 to 16 of 16

VBA Code running very slow to seperate 250 rows into 5 categories

Threaded View

Hareborn VBA Code running very slow to... 09-29-2015, 01:35 PM
Kaper Re: VBA Code running very... 09-29-2015, 01:46 PM
skywriter Re: VBA Code running very... 09-29-2015, 01:47 PM
Hareborn Re: VBA Code running very... 09-29-2015, 01:59 PM
skywriter Re: VBA Code running very... 09-29-2015, 03:27 PM
Hareborn Re: VBA Code running very... 09-29-2015, 03:44 PM
skywriter Re: VBA Code running very... 09-29-2015, 04:05 PM
Hareborn Re: VBA Code running very... 09-29-2015, 04:25 PM
skywriter Re: VBA Code running very... 09-29-2015, 04:34 PM
Hareborn Re: VBA Code running very... 09-29-2015, 04:54 PM
skywriter Re: VBA Code running very... 09-29-2015, 05:10 PM
skywriter Re: VBA Code running very... 09-29-2015, 06:40 PM
Hareborn Re: VBA Code running very... 09-29-2015, 07:11 PM
skywriter Re: VBA Code running very... 09-29-2015, 10:40 PM
Hareborn Re: VBA Code running very... 09-30-2015, 05:19 AM
skywriter Re: VBA Code running very... 09-30-2015, 11:31 AM
  1. #15
    Registered User
    Join Date
    09-29-2015
    Location
    Gainesville, FL
    MS-Off Ver
    2013
    Posts
    7

    Re: VBA Code running very slow to seperate 250 rows into 5 categories

    Skywriter that was the kick in the teeth I needed. The row keys I am using (MNoticeMain is one of them) change location every time the loop runs and a row gets added. I had placed the keys outside the loop which was causing them to find their position once and the loop to keep over writing on itself. I moved them into the loop so that they get rechecked each time the loop runs and it works great now, Thank you.
    Last edited by Hareborn; 09-30-2015 at 05:23 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. code running to slow and to long
    By Pilot5000 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-03-2015, 05:39 AM
  2. Slow running Code
    By Ausadian in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-25-2015, 04:41 PM
  3. Slow running code
    By phil2006 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-13-2013, 08:02 AM
  4. vba code running too slow
    By hitsujicute in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-31-2013, 06:00 PM
  5. VBA Code running very slow. Need help
    By krjoshi in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-21-2013, 02:13 PM
  6. Slow running code
    By Rick_Stanich in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-06-2008, 12:49 PM
  7. Code running slow
    By lou031205 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-08-2007, 12:20 PM

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