software

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 quot;DEPT1datesquot;.

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 quot;DEPT2datesquot;.

Thanks in advance for trying to help.

Bob--
bob777
------------------------------------------------------------------------
bob777's Profile: www.excelforum.com/member.php...oamp;userid=28504
View this thread: www.excelforum.com/showthread...hreadid=507198Why 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)

quot;bob777quot; gt; wrote in
message ...
gt;
gt; Hi all,
gt;
gt; Is it possible to automatically incorporate the name of the worksheet
gt; in the name of a range, eg I want to name cells A1 to A10 of a
gt; worksheet called DEPT1 quot;DEPT1datesquot;.
gt;
gt; I shall then create additional copies of this worksheet that will be
gt; named DEPT2, DEPT3 etc, so that the range of cells A1 to A10 of
gt; worksheet DEPT2 is called quot;DEPT2datesquot;.
gt;
gt; Thanks in advance for trying to help.
gt;
gt; Bob
gt;
gt;
gt; --
gt; bob777
gt; ------------------------------------------------------------------------
gt; bob777's Profile:
www.excelforum.com/member.php...oamp;userid=28504
gt; View this thread: www.excelforum.com/showthread...hreadid=507198
gt;