Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Defining Variables with Same Name in Different Worksheets
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Defining Variables with Same Name in Different Worksheets
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. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "mhyzak" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Name Defining | Excel Discussion (Misc queries) | |||
Compare two variables across two worksheets | Excel Worksheet Functions | |||
VBA defining variables | Excel Discussion (Misc queries) | |||
Defining | Excel Discussion (Misc queries) | |||
solver and defining all variables different than one another | Excel Discussion (Misc queries) |