View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Range Name Limitations - Max Refers To Length?

It wasn't the refers to length that was the problem. It was my reference to
the worksheet name in my code that was the problem. Thanks for your help.

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