How to create a defined named range in google sheets using script

Question

Is it possible to create named ranges in Google sheets using google script? I would then want the spreadsheet to be able to use these in formulas.

Possible duplicate of [setNamedRange() outside of the spreadsheet container?](http://stackoverflow.com/questions/12323961/setnamedrange-outside-of-the-spreadsheet-container) — Rubén, Nov 27 '16 at 15:51

score 2 · Answer 1 · edited May 23 '17 at 10:33

2

You may want to check out this post:

setNamedRange() outside of the spreadsheet container?

and see if that helps you ..

edited May 23 '17 at 10:33

Community

1
1

answered Dec 08 '14 at 12:30

JPV

26,499
4
33
48

score 1 · Answer 2 · answered Apr 13 '21 at 08:44

Class SpreadSheet has the method setNamedRange(name, Range) that can be used.

var ss = SpreadsheetApp.getActiveSpreadsheet();
ss.setNamedRange("myNamedRange", SpreadsheetApp.getActiveRange());

Link to the Google Documentation: https://developers.google.com/apps-script/reference/spreadsheet/spreadsheet?hl=en#setnamedrangename,-range

With me the pitfall was that I thought the method setNamedRange() belonged to the Class Range or Class Sheet. But turns out it belongs to the SpreadSheet Class.

How to create a defined named range in google sheets using script

2 Answers2