Select your range.
insert|name|Define
In the Names in workbook box, include the sheetname:
sheet1!myList
or
'sheet 1'!myList

You can have multiple worksheets each with a name of MyList.

====
If you go back to that insert|name dialog, you'll see your names--the names that
include the worksheet name to the right hand side are sheet level names.

If you work with names, do yourself a favor and get a copy of Jan Karel
Pieterse's (with Charles Williams and Matthew Henson) Name Manager:

You can find it at:
NameManager.Zip from http://www.oaltd.co.uk/mvp

Jan Karel has an option in that addin that will allow you "globalize" the name
or "localize" it.



Pierre wrote:

Hi all,
In a macro I use a named range. I want to use the same macro in similar
sheets in the same workbook. But each time I name the same range in
another sheet, the first one is canceled. How can I create the name in
all the sheet ?

It is probably possible as when you copy a sheet in the same workbook,
you have the same name in all the sheets.

Thanks


--
Pierre
------------------------------------------------------------------------
Pierre's Profile: http://www.excelforum.com/member.php...fo&userid=3754
View this thread: http://www.excelforum.com/showthread...hreadid=396828

--

Dave Peterson