Google Spreadsheet: How to name a range using Google Apps Script

Question

I am using the following code to name a range:

var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheets()[0];

var rangeToName = sheet.getRange(column, column - 1, 1,values.length + rowOffset);
var rangeName = 'F' + '2';

ss.setNamedRange(rangeName, rangeToName); // SCRIPT CRASHES HERE

When executing this script, it fails with the error message: The name you specified for this range is not a valid name.

I get this error whenever I use a concatenated string (it does not matter if I use to delimit the string with ' or ").

How can I create the name of a range by concatenating two strings or a string and number?

wchiquito · Accepted Answer · 2013-11-09 11:16:19Z

1

As indicated:

The specified range name is ambiguous with a cell reference.

For more information, see Named and protected ranges.

answered Nov 9, 2013 at 11:16

wchiquito

16.6k2 gold badges37 silver badges46 bronze badges

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

Comments

AlexR · Accepted Answer · 2013-11-09 11:08:33Z

1

I have found the error:

The name for the range may not look like a reference to a cell, e.g. "F2" is an invalid name as it could be a cell. A name may not contain a "-" character.

answered Nov 9, 2013 at 11:08

AlexR

5,6629 gold badges79 silver badges132 bronze badges

1 Comment

Pankaj Over a year ago

"A name may not contain a "-" character."--helped

Collectives™ on Stack Overflow

Google Spreadsheet: How to name a range using Google Apps Script

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related