Why not just create worksheet level names.

In the Names dialog, instead of using a names of say Dates, set it to
Sheet1!Dates, and the Sheet2!Dates on Sheet2.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"bob777" wrote in
message ...

Hi all,

Is it possible to automatically incorporate the name of the worksheet
in the name of a range, eg I want to name cells A1 to A10 of a
worksheet called DEPT1 "DEPT1dates".

I shall then create additional copies of this worksheet that will be
named DEPT2, DEPT3 etc, so that the range of cells A1 to A10 of
worksheet DEPT2 is called "DEPT2dates".

Thanks in advance for trying to help.

Bob


--
bob777
------------------------------------------------------------------------
bob777's Profile:
http://www.excelforum.com/member.php...o&userid=28504
View this thread: http://www.excelforum.com/showthread...hreadid=507198