I can't be sure without an example of range, and the formula you want to use the names, but I suspect you can use a single dynamic name instead (a dynamic name will have different value depending the cell it is called from).