Class NamedRange

    • Named ranges are spreadsheet ranges with associated string aliases that can be created, accessed, and modified.

    • Methods available for NamedRange include getting and setting the name and range, and removing the named range.

    • Accessing or modifying NamedRange properties requires specific authorization scopes.
    Named Range

    Create, access and modify named ranges in a spreadsheet. Named ranges are ranges that have associated string aliases. They can be viewed and edited via the Sheets UI under the Data > Named ranges... menu.

    Methods

    Method Return type Brief description
    get Name()
    		String Gets the name of this named range.
    get Range()
    		Range Gets the range referenced by this named range.
    remove()
    		void Deletes this named range.
    set Name(name)
    		Named Range Sets/updates the name of the named range.
    set Range(range)
    		Named Range Sets/updates the range for this named range.

    Detailed documentation

    get Name()

    Gets the name of this named range.

    Return

    String — the name of this named range

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/spreadsheets.currentonly
    • https://www.googleapis.com/auth/spreadsheets

    get Range()

    Gets the range referenced by this named range.

    Return

    Range — the spreadsheet range that is associated with this named range

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/spreadsheets.currentonly
    • https://www.googleapis.com/auth/spreadsheets

    remove()

    Deletes this named range.

     // The code below deletes all the named ranges in the spreadsheet. 
 const 
  
 namedRanges 
  
 = 
  
 SpreadsheetApp 
 . 
 getActive 
 (). 
 getNamedRanges 
 (); 
 for 
  
 ( 
 let 
  
 i 
  
 = 
  
 0 
 ; 
  
 i 
 < 
 namedRanges 
 . 
 length 
 ; 
  
 i 
 ++ 
 ) 
  
 { 
  
 namedRanges 
 [ 
 i 
 ]. 
 remove 
 (); 
 }

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/spreadsheets.currentonly
    • https://www.googleapis.com/auth/spreadsheets

    set Name(name)

    Sets/updates the name of the named range.

     // The code below updates the name for the first named range. 
 const 
  
 namedRanges 
  
 = 
  
 SpreadsheetApp 
 . 
 getActiveSpreadsheet 
 (). 
 getNamedRanges 
 (); 
 if 
  
 ( 
 namedRanges 
 . 
 length 
 > 
 1 
 ) 
  
 { 
  
 namedRanges 
 [ 
 0 
 ]. 
 setName 
 ( 
 'UpdatedNamedRange' 
 ); 
 }

    Parameters

    Name Type Description
    name
    		String The new name of the named range.

    Return

    Named Range — the range whose name was set by the call

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/spreadsheets.currentonly
    • https://www.googleapis.com/auth/spreadsheets

    set Range(range)

    Sets/updates the range for this named range.

    Parameters

    Name Type Description
    range
    		Range The spreadsheet range to associate with this named range.

    Return

    Named Range — the named range for which the spreadsheet range was set

    Authorization

    Scripts that use this method require authorization with one or more of the following scopes :

    • https://www.googleapis.com/auth/spreadsheets.currentonly
    • https://www.googleapis.com/auth/spreadsheets
    Create a Mobile Website
    View Site in Mobile | Classic
    Share by: