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).