var numRows = range.getNumRows();
for (var i = 1; i <= numRows; i++) {
var currentValue = sheet.getCell(i,1).getValue();
var withString = 0;
range.getCell(i,1).setValue(val + 1);
}