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