//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