Add a named range to a sheet. Now make a copy of that sheet into the same
workbook (Hold down the Ctrl key and drag and drop the sheet or right click
the sheet and select move or copy and make a copy of the sheet). You will now
have two named ranges with the same name on two different sheets...
--
HTH...

Jim Thomlinson


"Epinn" wrote:

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