Range Name Limitations - Max Refers To Length?

[Barb Reinhardt]

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

 

[ShaneDevenshire]

Hi Barb,

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

 

[Dave Peterson]

I thought that the limit was 256 characters, but I must be wrong if you're
failing before you exceed 110 characters.

It may be better to create the range and then name it instead of using a lot of
addresses.

Dim myRng as range
with activesheet
set myrng = union(.range("a1"), .range("c2:x99"), .... .range("iv99"))
end with

myrng.name = "HiThere"

or if it's a worksheet level name.

with myrng
.name = "'" & .parent.name & "'!HiThere"
end with

 

[Barb Reinhardt]

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

 

[Barb Reinhardt]

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