Use a variable when setting the getRange(value)

Question

Is it possible to use a captured value inside a getRange(value) code? If so, what do i need to change here? It keeps failing on the last line of code and i have tried a few different options.

function test(row) { 
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();// Define active sheet
  var amountdue = sheet.getRange("A30").getValue();// Capture amount due
  var rownumber = sheet.getRange("A30").getValue();// Capture row number
  sheet.getRange("B30").setValue(amountdue);// Paste amount due
  sheet.getRange("C"&rownumber).setValue(amountdue);// Paste amount due using captured row number
}

Harold · Accepted Answer · 2014-02-21 16:15:07Z

3

try that code:

function test(row) { 
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();// Define active sheet
  var amountdue = sheet.getRange("A30").getValue();// Capture amount due
  var rownumber = sheet.getRange("A30").getRow()// Capture row number
  sheet.getRange("B30").setValue(amountdue);// Paste amount due
  sheet.getRange(rownumber,3).setValue(amountdue);// Paste amount due using captured row number
}

What I corrected:
when you are trying to get the row use the formula getRow().
When you are trying to set the value to a cell with the retrieved row use the formula getRange(Integer row,Integer column) to point the good cell.

answered Feb 21, 2014 at 16:15

Harold

3,3671 gold badge20 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Use a variable when setting the getRange(value)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related