Not correct Bill.

See http://www.xldynamic.com/source/xld.Names.html

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bill Martin -- (Remove NOSPAM from address)"
wrote in message ...
Watercolor artist wrote:
I want to give the same cell in two different worksheets the same name,
"Company," but Excel won't allow me to. Is there a way to do that?

--------------

If by "worksheets" you actually mean worksheets and not workbooks, then I
don't
believe you can do what you want. Range names are defined across the
entire
workbook, not for individual sheets. That's kind of the point of names --
to
make it easy to reference stuff from other sheets.

You might be able to convince "labels" to do what you want. I've never
played
with them enough to know, but I believe they're local to a sheet rather
than global.

Bill