Search the Community

Greetings! So I have been enjoying leveraging the Excel UDF but have run into a little trouble with the _Excel_RangeReadEx function. I am getting an error that says this : I then found this ( https://www.autoitscript.com/forum/topic/169779-excel-range-find-function-giving-bad-results/#comment-1240352 ) And gave his "Slightly modified" version of the script a go with the same error except the UDF was excel2 as I couldn't over-write the original. The function that leverages this is as follows : Func rangeFinder () $inputDist = GUIctrlRead ($dispDist) Local $finderKeeper001 = _Excel_RangeFindEx ($oWorkbook, $inputDist) ConsoleWrite ($finderKeeper001[1]) EndFunc The other functions within the same ( entire ) script function well so it's just this that's giving me issues. In summary I am just looking for the script to locate the cell(s) that contain that value and return it's location so I can then further process things in my little world Thanks for your time!