Monthly Archives: October 2011

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

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 | 12 Comments

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

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 | 3 Comments