Tag Archives: Linear search

VBA searching shootout between WorksheetFunction.Match: Performance Pros and Cons

It is a rainy day here in Norfolk so … Prompted by a claim that searching using a variant array was much faster than calling MATCH from VBA I thought it was time for a detailed performance analysis. I shall … Continue reading

Posted in Uncategorized | Tagged | 8 Comments