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
|