Davey,

What you will probably find is that you have local and global versions of
the same name (it happens <g).

To check, go to a worksheet where you know there is a local name and
double-check it is there local. Then go to another sheet, and check it. You
will probably see it there, but without the sheet name. SO go back to the
first sheet and delete it. Does it still exist, but without the sheet name?

--

HTH

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


"davey" wrote in
message ...

Ron and Bob,

Thanks for your help. I understand now. Yes, "estimate" is a
worksheet.

Now, is there any quick and simple way to change my "local" ranges to
"global" ranges? I don't recall ever setting them up as "local" but I
am thinking this happened when I merged parts of 2 workbooks together.

So, as I asked above, is there any simple way to make them global?

Even if not simple, is there a way to do it without starting from
scratch?

Thanks!

- Davey


--
davey
------------------------------------------------------------------------
davey's Profile:
http://www.excelforum.com/member.php...o&userid=24340
View this thread: http://www.excelforum.com/showthread...hreadid=383680