G Guest Mar 30, 2005 #1 I want to use the same name, month9, to refer the same range of cells, but on different sheets, how do i turn off the global define?
I want to use the same name, month9, to refer the same range of cells, but on different sheets, how do i turn off the global define?
D Dave Peterson Mar 30, 2005 #2 When you define the name (Insert|name|Define), include the sheet name in the "names in workbook" box: sheet1!month9 or 'sheet 1'!month9 You can select your range and type this in the name box (to the left of the formula bar), too.
When you define the name (Insert|name|Define), include the sheet name in the "names in workbook" box: sheet1!month9 or 'sheet 1'!month9 You can select your range and type this in the name box (to the left of the formula bar), too.
