I have an ActiveX button an a sheet that when clicked, copies the entire sheet to the end of the workbook with a new name based. Within a hidden sheet is a named table and a named range based on a column in that table. There are other named ranges on a different hidden sheet (not based on...