This pops up after I copy data from one sheet to another using a VBA sub. The sheet contains named ranges with a worksheet scope so I don't know why that would be causing this error. If I click one of the cells with the #NAME? error and drag the formula across the other cells the error goes away and the values return. If I hit CTRL+Z to undo the values are still there. I have tried disabling and enabling automatic formulas to no avail.