Syntax for setNamedRange function to define Named Range with column range (A:A)

Viewed 23
var ss = SpreadsheetApp.getActive();
var namedRanges = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1").getNamedRanges();
var range = ss.getSheetByName("Sheet1").getRange(namedRanges[0].getRange().getA1Notation());

namedRanges[0].remove();

ss.setNamedRange("NewName", range);

The setNamedRange function sets the new named range with Range A1:A275 but not A:A because of which when I add new rows the named range doesn't include it.

Please tell me how to make setNamedRange add Named Range with a column range (A:A).

0 Answers
Related