How to write a value in excelsheet

[Sam137]

Thanks that perfectly worked out.. Can you please explain what do you mean by :

$aFound[1][3], $aFound[1][2] + 3 in the function _ExcelWritecell

[water]

$aFound[1][3] = Row as retruned by _ExcelFindInRange

$aFound[1][2] + 3 = Column as returned by _ExcelFindInRange + offset of the column where you want to write to

[Sam137]

what _ExcelFindInRange will return is no matches found ?

[Sam137]

$strFound = _ExcelFindInRange($oExcel, $ConcatVal, "D1:D200")
         ;_ArrayDisplay($strFound)
         If Not @error Or UBound($strFound) < 2 Then
          MsgBox(0,"Here i am","hello")
         $ProcYN = _ExcelReadCell($oExcel, $strFound[1][2], $strFound[1][2] + 1)
         EndIf

I want get into if loop only is there is a match found. How can it be done

[water]

In AutoIt all/most functions set @error to denote a problem. I would therefore change the code:

$strFound = _ExcelFindInRange($oExcel, $ConcatVal, "D1:D200")
If Not @error Then
    For $iIndex = 1 to $strFound[0][0] ; Element 0, 0 contains the number of rows in the array
           $ProcYN = _ExcelReadCell($oExcel, $strFound[$iIndex][2], $strFound[$iIndex][2] + 1)      
    Next
EndIf

And yes, the @error codes are documented in the header of the function - so please have a look at the UDF and check how the function returns data or errors.

Edited September 23, 2011 by water