Use the following conventions when naming a range.
Range names can be up to 15 characters long.
Range names are case-sensitive. For example, "myrange" and MYRANGE are not considered to be the same name and can refer to two different ranges.
Names for ranges cannot contain spaces. Also, do not start a name with an ! (an exclamation point), and do not include any of the following characters in a range name:
, (comma) | + (plus sign) | < (less than) |
; (semicolon) | - (minus sign) | > (greater than) |
. (period) | * (asterisk) | @ (at sign) |
? (question mark) | / (slash) | # (pound sign) |
& (ampersand) | { (left curly brace) |
Do not create names that look like cell addresses, such as Q2 or FY96; or names that begin with numbers, such as 20DEC. Do not use @function names or keyboard key names, such as HOME, as range names.