Hi All,New to Power Automate and VBscripting and can't seem to decipher this. I used the following code to select the line item in a table containing the word, for instance, "TREE", in the table. But this code only works if the current active cell in the table has the word "TREE". How do I enhance this code by making it do a line by line search for "TREE" in the TABLE if it could not be found from the current cell in the TABLE. I was thinking of doing an If-Else or Do-Loop or try other alternatives but could not get any to work. Please let me know. Thank you. I appreciate it.
For i = 0 To session.findById("wnd[0]/usr/tblSAPDV70ATC_NAST3").VisibleRowCount - 1
If session.findById("wnd[0]/usr/tblSAPDV70ATC_NAST3/ctxtDNAST-KSCHL[1," & CStr(i) & "]").Text = "TREE" Then session.findById("wnd[0]/usr/tblSAPDV70ATC_NAST3").getAbsoluteRow(i).selected = True
End If
Next