Results 1 to 20 of 24

Thread: Speed up Macro

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 10-01-2018, 08:41 AM #15
    p45cal
    p45cal is offline
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,970
    Quote Originally Posted by Paul_Hossler View Post
    Could you use that macro with your test data and let me know the relative performance?
    It's there in msg#10, under TEST. (50 times faster than GetValues which has a performance of 1. All the macros are rated using GetValues as a base, so LookupCopy is 5230 times faster than GetValues.)
    2018-10-01_170834.jpg
    (The GetValues No Exit For is the OP's original macro, the GetValues Exit For is a version of it where I added an Exit For line within the inner loop to stop searching if a match was found)
    Last edited by p45cal; 10-01-2018 at 09:20 AM.
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules