Didn't see where this started?

I'm not sure this is what you're asking so if it's not just store it in your
memory bank......

You can create one named range that refers to the active sheet only instead
of creating the a named range for each different sheet:

Name: Rng
Refers to: !$A$1:$A$10

So, if you're on sheet1 and you enter this formula: =SUM(Rng), it'll refer
to sheet1. If you're on sheet10 and enter the same formula it'll refer to
sheet10.

Biff

"Epinn" wrote in message
...
Note: This is a continuation of a previous discussion which you don't
really need.

Dave,

I did an experiment. I opened a brand new workbook. On Sheet1, I selected
A1:A10 and defined it with a name "Range123." Then, on Sheet2, I did the
same. As soon as I did that, "Range123" from Sheet1 no longer existed. So,
I don't really understand how the user can have the same named ranges within
one workbook? You know what, I even took out the reference to Sheet and
tried to force in just the cell reference; but Excel won't let me. What am
I missing here? Wonder if *two* workbooks are involved when we talk about
"same name?"

Sounds like you were talking about VBA. I didn't pick this up.

Look forward to your comments.

Epinn