Google Sheets Script Copy Values From Array To Column
I'm have an issue where I'm trying to copy values from an array to another column within my active sheet. While I have been following code samples and tutorials on copying values,
Solution 1:
sheet.getRange wants at least 2 arguments: (row, col) or (row, col, number or rows, number of cols)
sheet.getRange(resultsArray.length) is not a valid range, so you probably need:
sheet.getRange(1,1,resultsArray.length,1)
Baca Juga
- How To Find The Last Cell With A Value At The End Of A Column That Is Shorter Than Other Columns In Google Sheets?
- How Can I Create Batch In Javascript Loop To Select X Rows Then Next X Rows Until All Rows Are Done?
- How To Find The Last Cell With A Value At The End Of A Column That Is Shorter Than Other Columns In Google Sheets?
Post a Comment for "Google Sheets Script Copy Values From Array To Column"