Reply to thread

Message: [QUOTE="deltaquattro, post: 6436410"] Hi guys! I'm creating a small library of utilities for VBA programming, and right now I'm completing my ArrayManagement and CollectionManagement module. I was considering different solutions for the classical case of searchin an array or collection for a specified elements. So far I've considered using Worksheetfunction.VLOOKUP, Worksheetfunction.Match (needs some care to take into account the "element not found" case) for the arrays. I also developed an handy binary search function for sorted arrays, but it works only for 1D numeric arrays (sorted in either nonincreasing or nondecreasing order) but I have no idea on how to extend it multiD/non numeric arrays (if that's possible at all). Also, I would like to find some smart "Is Nothing"-based trick for searching in a collection. and Any suggestion/alternatives? Thanks, Best Regards deltaquattro ps if anybody is interested, I can post my "rough" attempts at a solution. [/QUOTE]