Clear (not delete) all NamedRanges in google spreadsheet -
i have tons of namedranges in spreadsheets. areas enter data. how function clear values in namedranges @ once? (all found far this, clears 1 specific range)
function clearrange1() { //replace 'sheet1' actual sheet name var sheet = spreadsheetapp.getactive().getsheetbyname('sheet1'); sheet.getrange('b7:g7').clearcontent(); }
i believe this. didn't see way progamatically names of of ranges in spreadsheet. if there function that, great know it.
function clearallnamedranges() { var ss = spreadsheetapp.getactive(); var namedranges = [ "sheet1!a3:b5", "rangename1", "myfunsheet!c5:h26" ]; namedranges.foreach(function(rangename) { ss.getrangebyname(rangename).clearcontent(); }); }
Comments
Post a Comment