ExcelCom Column Search

[Cush 0]

Hi,

I'm a big fan of ExcelCom but there's a function missing I think would be really useful.

In Excel, I quite often want to search a known column to find a known value, and then I want the row number of the matching row returned, so that I can do other things with the data on that row.

AFAIK, XL_Search will search for the data, and return an array of matches, but it doesn't give the row number reference.

Is it possible to have a function that does this, or tweak XL_Search to return the row reference? I've had a look at the current code but it's way over my head.

Any help would be appreciated.

Paul

[JohnBailey 1]

I know this is nearly an ancient post, but if you're still around or someone else stops by would http://www.autoitscript.com/forum/index.php?showtopic=34302 using _ExcelFindInRange work for your purposes?