The problem is probably the length of the Refersto string when Excel appends
the sheetname.

Select all of the cells, using Ctrl-click, and then just type the name into
the Names box (the box to the left of the formula bar that shows the active
cell.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"RadioTraffic" wrote in message
...
I need to define a name for 31 cells in a worksheet. They are all in the
same column, but they are about every 11th line. Excel will only let me
use
23 of those 31 cells in my range. I need this because it also, will not
let
me average those cells, which is ultimately what I am trying to do. Any
advise would be appreciated. Thanks

Georgia