+ Reply to Thread
Results 1 to 6 of 6

Inject some processing speed to this easy macro .

  1. #1
    Forum Contributor
    Join Date
    12-12-2017
    Location
    New Zealand
    MS-Off Ver
    Ms Office 2016
    Posts
    430

    Angry Inject some processing speed to this easy macro .

    Hello all ,

    Not have a lot of luck today .
    The macro in this sheet is very slow over 490,000 rows , can it be improved .

    It simply just counts how many horses are there , run it and it will give results . Just need more speed .

    Thanks .
    Attached Files Attached Files
    I am grateful for all answers to my questions .
    Also i give a reputation even if not answered .

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Inject some processing speed to this easy macro .

    .
    Is the goal to count the number of rows that are used ... or ... how many unique horses names exist ?

  3. #3
    Forum Expert
    Join Date
    12-10-2006
    Location
    Sydney
    MS-Off Ver
    Office 365
    Posts
    3,523

    Re: Inject some processing speed to this easy macro .

    Try this as it doesn't use looping:

    Please Login or Register  to view this content.
    Bear in mind that a data set 42 columns wide by 490,000 rows (there is "only" a maximum of 1,048,576 rows on a tab) is a huge data set and will slow Excel.

    Robert
    ____________________________________________
    Please ensure you mark your thread as Solved once it is. Click here to see how
    If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post

  4. #4
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Inject some processing speed to this easy macro .

    .
    Another method if you are only checking Column AH for unique terms :

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    12-12-2017
    Location
    New Zealand
    MS-Off Ver
    Ms Office 2016
    Posts
    430

    Re: Inject some processing speed to this easy macro .

    Logit it is to count unique horses names that exist .

    I will test out these two macros . Thanks .

  6. #6
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,028

    Re: Inject some processing speed to this easy macro .

    Another option
    Please Login or Register  to view this content.
    takes me approx 2secs for 530,000 rows.

+ 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] How to speed up slow processing issue
    By Perk1961 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 10-27-2015, 03:24 PM
  2. Excel Processing Speed
    By wilfrid147 in forum Excel General
    Replies: 10
    Last Post: 08-03-2015, 08:19 AM
  3. Speed up the processing
    By robtuby in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-31-2014, 11:41 AM
  4. Excel processing speed
    By tony.nz in forum Excel General
    Replies: 2
    Last Post: 11-13-2009, 03:42 PM
  5. Increasing Processing Speed
    By boylejob in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-11-2008, 02:19 AM
  6. Processing speed
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-07-2008, 02:21 PM
  7. [SOLVED] speed of processing
    By Chas in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-08-2006, 09:20 AM

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