Names

A name is defined by a formula that returns any type of value, array or reference. Names may consist of a wide variety of unicode symbols and must be distinct from cell references in either a1 or rc-notation. Names can be defined within various contexts as shown below in descending order of precedence:

scope	context
formula	name argument of LET function
sheet	sheet-level name with sheet name prefix
workbook	workbook-level name with workbook name prefix
application	global name referencing hidden addin workbook (xll / xlm)

Range references can be defined by range names or structured references in tables. Multiple area range names may contain several hundred references although are limited to 255 characters when entered from the user interface. Named ranges can be defined relative to a cell and may also refer to the active sheet by prefixing with an exclamation mark so that =!RC refers to the active cell. Large arrays are supported as names though there is a limitation on saving names with more than 8192 characters to xlsm files. Names may also refer to function names (vba, xll or xlm) and arguments can be passed to the names in the same way as the functions themselves.