When you wish to create a WS specific (local) named range,
Select the range,
Click in the "name box",
And enter the sheet name *before* the range name, followed with an
exclamation point.
Sheet1!myrange
Sheet2!myrange

If you know ahead of time that you will need locally named ranges, you could
create them on a single WS, then, you can copy this sheet, where each copy
will then already contain it's own locally named ranges.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Tonilrac" wrote in message
...
I have sheet that does that. It has the same name for similar ranges, only
they are specific to the sheet, but I don't seem to be able to do it