Thank you all for your response. What I want is very simple, nothing to do with VBA.

Basically, I was trying to have the *same name* for A1:A10 on two sheets (within the same workbook) respectively. Jim and Biff gave me the answer.

I don't think I can name A1:A10 on Sheet1 as "ABC" and then also name B1:B10 on Sheet2 as "ABC" as well. I used insertnamedefine and I also use the Sheet# to qualify the range, but no luck.

Can someone confirm this is not possible please?

The Name Manager may come in handy one of these days. Thanks Dave.

Epinn

"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