1 reply to this topic

[JDMcDowall55]

Find the first one is easy

 

xl.Range("A:A").Find(idd).row

 

return the row in with the contents of iDD was found.

How do I find the next row, and the next...

[Jackie Sztuk _Blackholyman]

Example of using the .findnext() method

FullWBname = ____.xlsx ; enter full workbook name here
 
ComObjError(false)
Sheet := ComObjGet(FullWBname).ActiveSheet
ComObjError(true)
 
if Not Sheet 
{
        MsgBox, Could not access workbook
        ExitApp
}
 
InputBox, val, Enter Value to Find:, , , 200, 100
if Not Errorlevel
    if cell := Sheet.UsedRange.Find(val)
        while (cell.Address != firstAddress)
        {
            if (A_index = 1)
                firstAddress := cell.Address
            column := cell.column
            row := cell.row
            MsgBox, % "found " val " in call at `nrow:" Row "`ncol: " column
            cell := Sheet.UsedRange.FindNext(cell)
        }
Sheet := ""
msgbox done!
return