mardi 3 janvier 2017

Codes block has an syntax error

//For some reason this code block is giving an error and i can't figure out what is the matter with it. Any help is appreciated.

 function Submit(e) {
   var ss    = SpreadsheetApp.getActiveSpreadsheet();
   var s     = e.getActiveSheet();
   var range = e.getActiveRange();
   var cell  = range.getActiveCell();
   var cellValue  = ss.getActiveCell(9,17);




if( cellValue == <0 ){

  var report = s.getDataRange("A101:Q106");
  var numColumns = s.getLastColumn();
  var targetsheet = ss.getSheetByName("Report");
  var date = s.getSheetName();
  var target = targetsheet.getRange(targetsheet.getLastColumn() + 1 , 1);
  e.getRange(report).copyTo(target);
}

Aucun commentaire:

Enregistrer un commentaire