And so you have a perfect example of why you should never use global
scope with defined names unless it's *absolutely necessary*! If you
want names to be reusable on more than 1 sheet then they *must* be
defined with local scope as follows...

'Sheetname'!DefinedName

...where the sheetname is wrapped in apostrophes, and delimited from the
defined name by the exclamation character. Doing this will allow you to
reuse the name on as many sheets as desired. Note that the RefersTo
does not, however, need to be the same address on every sheet using the
name.

HTH

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion