Search:

Type: Posts; User: strat919; Keyword(s):

Page 1 of 3 1 2 3

Search: Search took 0.00 seconds.

  1. Re: Should this code be written differently? Takes way longer than sorting each sheet manually

    I didn't delete the entire line.

    It works perfectly now:) Thank you so much for your help Mr Yongle!
  2. Re: Should this code be written differently? Takes way longer than sorting each sheet manually

    I tried that, but got an error.... I will try it different ways
  3. Re: Should this code be written differently? Takes way longer than sorting each sheet manually

    The duplicates should not be "removed" in the code. There will be very few cases where there will exact duplicates...... but I would need to see if there were any..... and they would appear at the...
  4. Re: Should this code be written differently? Takes way longer than sorting each sheet manually

    <colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>

    A
    B

    </thead><tbody>
    1
    42.4822
    20.7458
  5. Re: Should this code be written differently? Takes way longer than sorting each sheet manually

    Sorry....maybe I was misunderstood.

    only a zero distance would show up in the results if there were any duplicates in the AB column
  6. Re: Should this code be written differently? Takes way longer than sorting each sheet manually

    Just returned from going out of town.

    I replaced the above code and it returned a lot of zero distance values

    I placed 500 initial entries, set it for 100 items to output, and it returned 100...
  7. Re: Should this code be written differently? Takes way longer than sorting each sheet manually

    Also forgot to mention, the cpu usage reaches 28% in excel....way better.

    I tried to edit the code to remove the duplicate deletion, but always got errors....lol.

    So everything is PERFECT...
  8. Re: Should this code be written differently? Takes way longer than sorting each sheet manually

    Yes.... Zero distances included in results sheet.

    Thanks for the info above:)
  9. Re: Should this code be written differently? Takes way longer than sorting each sheet manually

    It dramatically reduced the time!

    4500 entries was 5 min. initially, 3.5 min. with your version1 and 1.5 min. with version2

    12,500 entries was 24 min. version1 and now only 7.6 min with...
  10. Re: Should this code be written differently? Takes way longer than sorting each sheet manually

    One other thing that may not be important. I wasn't sure if you wanted all the code put in one module or in 3 separate modules.

    I put them all in one module and got errors. I put them in 3...
  11. Re: Should this code be written differently? Takes way longer than sorting each sheet manually

    Sorry..... I didn't answer your questions.

    - I will always need the shortest distance
    - Nothing else is required:)

    As far as the limit, here is how I plan to work. Just for your information....
  12. Re: Should this code be written differently? Takes way longer than sorting each sheet manually

    I'm going to have to address you as Mr. Yongle from now on:) It works perfectly.

    I entered 4500 lat long entries and the time for entire process was 3.5 min. It was taking little over 5 min...
  13. Re: Should this code be written differently? Takes way longer than sorting each sheet manually

    Hey Michael.......
    I know very little about any of this, but when I look at it and I could be totally wrong here.

    -
    Sub Text2Columns() all sheets need to be delimited
    -
    Sub...
  14. Re: Should this code be written differently? Takes way longer than sorting each sheet manually

    I guess you could say it picks x amount of lowest values out of all the sheets...not per sheet... and places them in master sheet. In the master result sheet it would have A,B,C,D,E like in all the...
  15. Re: Should this code be written differently? Takes way longer than sorting each sheet manually

    I forgot to mention the the merge was only used because of the next macro. I assume the merge is not needed.

    Also, I guess sorting would not be necessary after unique pairs if I could set the code...
  16. Re: Should this code be written differently? Takes way longer than sorting each sheet manually

    I'm not sure how to post table in here, but here is the initial and desired results. I wasn't using any headers. Probably easier for me with no headers.



    - initial latitude longitude would be...
  17. Re: Should this code be written differently? Takes way longer than sorting each sheet manually

    Here is all the code in order for all the steps that I have been using:


    Sub ExecuteAll()
    Call MergeColumnsAddComma
    Call GetUniquePairs
    Call Text2Columns
    Call deleteSheetByName
    Call...
  18. Re: Should this code be written differently? Takes way longer than sorting each sheet manually

    To be honest, I'm not sure how much data I will be sorting. I'm developing a addon for a flight simulator where the user will be able to add their own coordinates for 3d objects. I have no idea how...
  19. Re: Should this code be written differently? Takes way longer than sorting each sheet manually

    Ok..... I will able to run the macros without a merge. Yongle wrote me the code to get unique pairs from row A and can be spread over many sheets to alleviate the million row limit. It works...
  20. Re: Should this code be written differently? Takes way longer than sorting each sheet manually

    Thanks Vccolio:) I will try that. I'm nor sure if I can do away with the merge columns or move it in the sequence. The next macro depends on that. I will look into seeing if I could work around this....
  21. Re: Should this code be written differently? Takes way longer than sorting each sheet manually

    Thanks for your help everyone:) Unfortunately, nothing seems to make any difference. Maybe excel handles running macros concurrently differently rather than one at a time. Seems like when I run the...
  22. Re: Should this code be written differently? Takes way longer than sorting each sheet manually

    Do you mean turning......adding?
  23. Re: Should this code be written differently? Takes way longer than sorting each sheet manually

    I actually jumped the gun. When I ran your code changes, I sorted the 13 sheets when they were already sorted....I ran all the macro sequences again and it was still much slower than sorting each...
  24. Re: Should this code be written differently? Takes way longer than sorting each sheet manually

    That did the trick:) I didn't change the screenupdating, but will. Why does that make such a difference......just curious.

    Thanks a bunch!
  25. Should this code be written differently? Takes way longer than sorting each sheet manually

    I have some code to sort all sheets column E low to high. I have 18 sheets each with about a million rows. I can sort one sheet manually and it takes maybe 5 seconds. When I use this code, the 18...
Results 1 to 25 of 54
Page 1 of 3 1 2 3