This post has been of great help to me as it got me ALMOST to my goal.
Goal: Copy a number from Excel cell starting on A2 (A1 is a header), enter it into a web search, copy data from the result, and paste it into B2 (B1 is a header). Then continue down a list with the same process and paste the data into B3, B4, B5, etc.
Problem: Everything works, but it starts pasting the data from in B10 instead of B2. So, it pastes the data acquired from A2 into B10 (instead of B2), then pastes the data acquired from A3 into B11 (instead of B3), etc.
I am using the activity Assign to set the variable MYROW=TaxLienData.Rows.IndexOf(row) as the example shows. Then I have used the activity Write Value to set the Input Range to “B1”+ MYROW. I could not get the activity Write Cell to work at all which I think is due to fact I am using an Excel Application Scope.
I also tried using a Message Box to find out the value of MYROW and it starts with 0 then 1, 2, 3, etc., so I don’t think that part is the problem.
Could someone help with a nudge in the right direction, please? Sorry I cannot upload a Zip file with my work because I am a new user.