Cush Posted July 31, 2006 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
JohnBailey Posted March 21, 2007 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
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