It could also be that my Offset function isn't set up properly. Will have
to look at that further.
Thanks,
Barb Reinhardt



"ShaneDevenshire" wrote:

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