>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?<
Mark,
Here is a portion of text from the Fox help file for ASUBSCRIPT() function that will return either the row or the column referrence for a certain element in the array.
---Quote---
Returns the row or column subscript of an element from the element's number.
Syntax
ASUBSCRIPT(
, , )
, ,
If the array is one-dimensional, include the element number in and 1 in . ASUBSCRIPT( ) identically returns .
If the array is two-dimensional you must include both the element number and a value of 1 or 2 in . Specifying 1 in returns the row subscript of the element, and specifying 2 returns the column subscript.
---End quote---
I hope this is what you were looking for.
Sorin Stegaru
sorin@suzy.com