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?

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.

KSAPP wrote:

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?

--

Dave Peterson