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