Monthly Archives: October 2011

MATCH vs FIND vs Variant Array VBA Performance Shootout in Excel 2010

Posted on October 26, 2011 by fastexcel

When searching unsorted data in VBA I have always tended to use MATCH rather than FIND, mainly because early versions of Excel before Excel 2003 did not allow you to use FIND in UDFs. But prompted by a discussion in … Continue reading →

Posted in VBA | 25 Comments

Writing efficient VBA UDFs (Part 6) – Faster string handling and Byte arrays

Posted on October 18, 2011 by fastexcel

None of  the previous posts on writing efficient VBA UDfs (Part1,Part2,Part3,Part4,Part5) talked about handling strings in VBA. This could be a major omission since string-handling is one of VBAs slowest “features”. Suppose you want to find the position of the … Continue reading →

Posted in UDF, VBA | 6 Comments