Excel _Excel_RangeFind / find empty cells also

[kawumm3000]

Hi,

when I try this

Local $aResult = _Excel_RangeFind($oWorkbook, "*", "L1:L"&$iRow, Default, $xlWhole)

I only get cells with a value. But I also what to find empty cells. How can I do that?

Thanks
 

[Danp2]

Sounds like to want to retrieve all cells for a given range. If so, then you should use _Excel_RangeRead instead of  _Excel_RangeFind.

If I've misunderstood your request, then please explain further.

[water]

In the wiki you can find how to retrieve empty cells: https://www.autoitscript.com/wiki/Excel_Range#Empty_Cells