"arno" wrote in message ...

If the range is in a
hidden/protected sheet there's no way to find out what the name is.

Are you sure about that? Try this in the VBE Immediate Window:

For Each n in ThisWorkbook.Names : ? n.Name, N.RefersTo : Next

--