Skip to content Skip to sidebar Skip to footer

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)

Post a Comment for "Google Sheets Script Copy Values From Array To Column"