I’m stuck. I have a spreadsheet, which using a Vlookup and an Index formula and referencing a named range, returns a result based on an ID number in another cell. This works. However, I am using VBA to ‘translate’ the spreadsheet… this simply deletes the named ranges then re-adds them to another sheet (The code works to toggle between the two sheets – the references stay the same, but the sheets change between a German and an English sheet). The sheets are both re-named and the unreferenced sheet gets hidden.