I have no idea what you're doing wrong. On sheet1, I define the name
MyRange and in the refers to box I type =!$A$1:$A$10 and when I use the name
MyRange on sheet1 refers to A1:A10 on sheet1. When I use the name MyRange on
sheet2, it refers to A1:A10 on sheet2. And the same for the other sheets.


"Gilbert De Ceulaer" wrote in message
...
No, I did it, but it doesn't work,
Now I am creating the '2002'!LABELSVIN = '2002'!!$A$1:$A$10 one by one,
and that works, but I know (somebody thought be before) it is possible

"Wondering" wrote in message
t...
Works fine for me too. Did you put the "!" in the reference - eg.
!$A$1:$A$10 ? . If you didn't the name will refer to the range A1:A10
only on the sheet where you created it.

"Gilbert De Ceulaer" wrote in message
...
Sorry, but this gives me "xyzlabels" but only in the first of selected
worksheets.
I would like "xyzlabels" to be created in 10 or more worksheets.

"JE McGimpsey" wrote in message
...
One way:

Choose Insert/Name/Define:

Name in workbook: xyzlabels
Refers to: !$A$1:$A$10


In article ,
"Gilbert De Ceulaer" wrote:

How can I - in one operation - give the same name to the same range in
different worksheets ?
("xyzlabels" refer to the same (label)-range, but as well in sheet
"1999",
as in "2000", as in....)