Range names are defaulted to the sheet in which they are named.

Select a range................A1:F10 then define the name.

You will see the name refers to =Sheet1!A1:F10


Gord Dibben MS Excel MVP


On Tue, 16 Jun 2009 16:24:01 -0700, Té wrote:

How can I create a range name that can only be used for a particular
worksheet, instead of the entire workbook?