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...
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...
.findnext()
methodFullWBname = ____.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