I am familiar with Excel VBA but am new to Google Script Editing
I am trying to use a simple IF statement to insert a new line above line 2 if cells A2 & B2 are NOT Blank.
function AddaLine() {
if (B1 == false)
var spreadsheet = SpreadsheetApp.getActive();
spreadsheet.getRange('2:2').activate();
spreadsheet.getActiveSheet().insertRowsBefore(spreadsheet.getActiveRange().getRow(), 1);
spreadsheet.getActiveRange().offset(0, 0, 1, spreadsheet.getActiveRange().getNumColumns()).activate();
spreadsheet.getRange('A2').activate();
};
where cell B1 contains
=isblank(A2:B2)
or
function AddaLine() {
if (A2, B2 != null)
var spreadsheet = SpreadsheetApp.getActive();
spreadsheet.getRange('2:2').activate();
spreadsheet.getActiveSheet().insertRowsBefore(spreadsheet.getActiveRange().getRow(), 1);
spreadsheet.getActiveRange().offset(0, 0, 1, spreadsheet.getActiveRange().getNumColumns()).activate();
spreadsheet.getRange('A2').activate();
};
Every combination I can think of returns errors. Any help would be appreciated.
Aucun commentaire:
Enregistrer un commentaire