How to make the read cell dynamic

excel

#1

Hi, I have this case study that I need to read a data from an excel cell then type it into a search box. But I don’t know how I can loop it. For now, the value of cell in my read cell is specific (“A2”) I want it to be dynamic so it would pick up the data on the next row of the cell. Hope you can help me! Thanks in advance

image


#2

Hello @pml, does that mean you want to loop the Read Cell for each row?
Assuming you entry one by one to the same Input, you can achieve this by:

Excel Application Scope
 Set i = startRow
 While i<yourLimitHere
  Read Cell "A"+i.ToString
  Type Into the Input Box