Don't give up on your original question.

Pierre wrote:

Thanks a lot Dave.

You are right I can use the worksheet.name & RangeName.
Actually, that's what I did but as when copying the sheet in the same
workbook you generate the same named range in both sheet I was
wondering it is possible to do it manually.

--
Pierre
------------------------------------------------------------------------
Pierre's Profile: http://www.excelforum.com/member.php...fo&userid=3754
View this thread: http://www.excelforum.com/showthread...hreadid=396828

--

Dave Peterson