I'm trying to name cells on different sheets using the same name. Excel resists this by jumping to the other sheet which has a cell with that name to make you aware of the fact. Anyone know how you get round this? There must be a way because if you make a copy of a sheet with a named cell on it, it retains that duplicate name.