Select the sheet
Goto NameInsert NameDefine...
In the names type Sheet3!name or whatever the sheet is
Add the range in the RefersTo box
OK

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"digicat" wrote in
message ...

How do I make a sheet specific name?
That is exactly what I'm looking for.
The way I'm trying to do it doesn't work.
The name I have defined with a 3D-formula doesn't show in any of the
sheets and refers only to the first sheet anyway.
=Sheet1:Sheet3!$A$5:$M$52
When I'm building the formula single quote marks show around the
sheetnames, but they disappear when I hit th OK button.
='Sheet1:Sheet3'!$A$5:$M$52


--
digicat
------------------------------------------------------------------------
digicat's Profile:
http://www.excelforum.com/member.php...o&userid=14920
View this thread: http://www.excelforum.com/showthread...hreadid=502825