Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Matching/Finding/Search Array Element | Excel Programming | |||
Rules for element-by-element product in array multiplication | Excel Programming | |||
delete element is collection | Excel Programming | |||
Search array and return element No | Excel Worksheet Functions | |||
Array problem: Key words-Variant Array, single-element, type mismatch error | Excel Programming |