Defining Variables with Same Name in Different Worksheets

[mhyzak]

In a workbook with multiple worksheets, is it possible to define a name that
only applies to that particular worksheet? I would like to use the same
variable name on another worksheet, but for a different set of cells. I had
copied a worksheet to another worksheet in the workbook, and it seemed to do
this for some variable, but not all of them. Where would I enter the
information that indicates a particular variable name only applies to a
specific worksheet.

 

[Ragdyer]

You have to prefix the range name with the sheet name followed with an
exclamation point.

For example:

Select the range,
Click in the name box (left of the formula bar),
Type:
sheet1!mylist
And hit <Enter>

Go to Sheet2, select your range for that sheet, and do the same thing:
sheet2!mylist

Now, when you go to:
<Insert> <Name> <Define>

You'll see the range name on the left side, and the sheet name on the right
side of the "Define Name" window.