Good catch Jim.


Missed that. A named range can not duplicate a Range Reference. S1 is a
valid range reference.

In otherwords, if you did Range("S1"), is is cell S1 or your named range (if
it could hold that name).

So S_1 would work. (just to emphasize that numbers are permitted although
not as the first character).

--
Regards,
Tom Ogilvy



"Jim Cone" wrote in message
...
I get error 450 or error 1004, but they all go away when I remove the
numeric digit from the name... Ss works.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Nigel"
wrote in message
i get an error 400 with that....with either method actually.