Write Cell in Google Spreadsheet for each row

Hi, I have a Google Spreadsheet, I’ve already extracted data from it to a table, wich I used to paste values in a website and obtain data to a variable. The thing is that I want this value to be written into a cell in a specific column for each row but I keep getting this error: “Rango especificado no válido. (Parameter ‘Dirección de la celda’)”
I’m putting this into the Expressions Editor: " “B” + CurrentRow.ToString() ".

Any help would be appreciated

This is happening because you are referencing only the column, currentrow.tostring will not bring a number.
You need to put a counter to be able to increment the data insertion for each line.

Counter=Counter+1

and put
“B”+Counter.tostring

1 Like

Thanks for your response, that did it!

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.