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