you could use a named range instead of a named cell.. that way as long as thename exits the range it equals can change...