function Looping() { var app = SpreadsheetApp; var loopActiveSheet = app.getActiveSpreadsheet().getActiveSheet(); //var someCell = loopActiveSheet.getRange(8,1).getValue(); //someCell = someCell+5; //loopActiveSheet.getRange(9,1).setValue(someCell+5); //Logger.log(someCell); //------------ for (var i=8;i<12;i++){ var someCell = loopActiveSheet.getRange(i,1).getValue(); someCell = someCell+5; loopActiveSheet.getRange(i,2).setValue(someCell+5); //----------- //Logger.log('hello'); //Logger.log(i); } }