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? — Wicket
– Wicket, Commented Nov 27, 2016 at 15:51

Community · Accepted Answer · 2017-05-23 10:33:00Z

2

You may want to check out this post:

setNamedRange() outside of the spreadsheet container?

and see if that helps you ..

edited May 23, 2017 at 10:33

CommunityBot

11 silver badge

answered Dec 8, 2014 at 12:30

JPV

27.4k4 gold badges37 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Juuso Nykänen · Accepted Answer · 2021-04-13 08:44:33Z

1

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.

answered Apr 13, 2021 at 8:44

Juuso Nykänen

4484 silver badges14 bronze badges

Collectives™ on Stack Overflow

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

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related