Hi Barb,

The limit is 255 in 2003 or earlier, I haven't check 2007 but I don't think
it changed.

--
Cheers,
Shane Devenshire
Microsoft Excel MVP

"Barb Reinhardt" wrote:

I'm trying to modify a bunch of named ranges and I think I'm hitting a
limitation on the maximum length for the Refers to field. Does anyone know
what that is? The length of what I have is between 69 and 110

Thanks,
Barb Reinhardt