Cush 0 Posted July 31, 2006 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 Share this post Link to post Share on other sites
JohnBailey 1 Posted March 21, 2007 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? A decision is a powerful thing Share this post Link to post Share on other sites
