I've copied some sheets that had named ranges in them and this has copied the named ranges across too. Excel allows duplicate named ranges but then makes the Scope of that named range specific to the sheet it occurs in. I have renamed the ranges to make them unique but the Scope still shows as the actual sheet rather than the whole workbook. Does anyone know how i can chnage the Scope back to workbook without having to delete and recreate all of the named ranges?
25th Aug 2009 14:16