View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Range Name Limitations - Max Refers To Length?

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 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


--

Dave Peterson