Advertisement
Guest User

Untitled

a guest
Jan 17th, 2018
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. function addCells() {
  2.   var ss = SpreadsheetApp.getActiveSpreadsheet();
  3.   var sheet = ss.getSheetByName('reactions2');
  4.  
  5.   for (i = 1; i < 5; i++) {
  6.       var num1 = sheet.getRange(i,1).getValue();
  7.       var num2 = sheet.getRange(i,2).getValue();
  8.       sheet.getRange(i,1).setValue(num1+num2);
  9.       sheet.getRange(i,2).clear({contentsOnly: true});
  10.   }
  11.  // return Browser.msgBox(String(num2)+' hinzugefügt.');
  12. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement