The limit is on the length of the string that you use in the Refersto part
of the name. Can't be longer then 1024 characters when expressed in R1C1
notation.

--
Regards,
Tom Ogilvy

Mark Dabbs wrote in message
...
Hi all

I have a grid of non-contiguous cells that I wish to give a name from
within a Subroutine either by using

Name.Add "MyName", Selection

or by using

rngTemp.Name="MyName".

The problem is that once I get over about 220 distinct cells in the
non-contigous range an error message is thrown up
each time I try to give it a name. Any fewer cells and it works fine.

Is this an Excel 2000 limit?

Thanks
Mark

---------------
www.mfdabbs.com