+ 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
    Franklin , New Zealand
    MS-Off Ver
    2007
    Posts
    186

    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
    2007 Enterprise
    Posts
    4,836

    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
    2007
    Posts
    3,063

    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
    2007 Enterprise
    Posts
    4,836

    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
    Franklin , New Zealand
    MS-Off Ver
    2007
    Posts
    186

    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 Expert
    Join Date
    09-10-2017
    Location
    Chippenham
    MS-Off Ver
    365
    Posts
    5,607

    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)

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