_Excel_RangeFind use

[Rambert]

Hi everybody.

I am using function _Excel_RangeFind to look a value at excel file. That file only has one sheet.

There are about 4000 rows and 5 columns.

I need to look for a value in that range A1:A4000 and get the rest of values of that row.

So i am able to find a value that exists at excel file, but if i look for a value that is not in file how can i manage that error.

Resuming if i look for a value in cells range A1:A4000 and it's found, I am able to take the rest of values ( imagine value is found in A130 cell then i can get an array with values in cells A130 B130 C130 D130 E130) but if value is not found in any  cell i need show a msgbox and exit program.

My problem is when value is not found. I can't manage error.

Thanks and regards. 

[AutoBert]

Test one of the examples in helpfile and you see how to do this.

[Rambert]

I have read four scripts at help but i must be blind cause I can't get it

I will try to read again and if i don't get it, i will post here

thanks

[Rambert]

Nothing...

I have created a test scripts like help scripts number 1

I have changed only string to find ( 37000 to 99999)

I have created a folder named Extras at my folder scripts, and i have copied _Excel1.xls on it.

I have pressed F5 and tell me data has been searched...

but show me an empty array

Could you test it???

thanks and regards

 

Edited May 26, 2016 by Rambert

[Rambert]

One advise

I have modified function file as i have read here at forum cause i have autoit 3.3.14.0

https://www.autoitscript.com/forum/topic/182286-_excel_rangefind/?do=findComment&comment=1309096

Edited May 26, 2016 by Rambert

[AutoBert]

Can't you see all examples using: 

Local $aResult = _Excel_RangeFind($oWorkbook, "* Story", Default, Default, $xlWhole)
If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Excel UDF: _Excel_RangeFind Example 4", "Error searching the range." & @CRLF & "@error = " & @error & ", @extended = " & @extended)

same as you want: Showing MsgBox and Exit.

[Rambert]

Tested at this moment

Look my files attached

[Rambert]

i go bed

thanks and regards

[water]

Not finding a specified string is not regarded to be an error by the function. It always returns the number of found cells in the array. When there are no cells matching the search string then an empty array is being returned.
So check the number of Rows in the array. 0 means: Nothing found.

[Rambert]

How can i chek number of rows???

[water]

If UBound($aResult, 1) > 0 Then ... ; Find successful

 

[Rambert]

Thanks. I will check later