Cush Posted July 31, 2006 Share 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 Link to comment Share on other sites More sharing options...
JohnBailey Posted March 21, 2007 Share 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now