Anybody know if there is API routine that will do the equivalent of ASCAN, but will let you specify a given column to scan and return the row number of the matching cell? The problem with ASCAN is that it scans the entire array. If the information across columns is not unique, ASCAN is pretty useless! Doing the search in a FOR loop to access Row,Col is pretty slow. I'm looking for a fast alternative. Thanks!