As a workaround, note that you can use the union operator (,) to break
your ranges into smaller units:


Name in workbook: myrange1
Refers to: =Sheet1!$A$1:$F$1

Name in workbook: myrange2
Refers to: =Sheet1!$J$10:$K$15

Name in workbook: myrange3
Refers to: =(myrange1,myrange2)


In article ,
"Jim Rech" wrote:

The limit in the Define Name dialog's Refers To box is 255 characters. So
the number of areas a name created using it can have depends on their
addresses and the length of the sheet's name.