lundi 9 juillet 2018

If Statement Syntax

In this script the variable bankid evaluates to B1 but I cannot make this a condition but get an "if statement not defined"

    function BankTemplate() {
    //copy  all Bs!;
    var 
    bp=SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Bs").activate();
    var bankid = bp.getSheetValues(3, 6, 1, 1); 
    If(bankid == "B1")
    {
      var 

 bp=SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Bs").activate();
      var arraytocopy =  bp.getSheetValues(1, 1, 60, 20);
      var arrayNew  =  bp.getRange(65, 1, 60, 20).setValues(arraytocopy);
    }

Aucun commentaire:

Enregistrer un commentaire