Hi all, I have a workbook with many sheet that have named ranges. I have copied one on the sheets and have renamed the ranges within the sheet. i.e
Sheet call Watch ... was copied and named Watch_1
In this sheet there are many named ranges i.e Watch1 (which is in sheet "Watch") has been renamed WatchCode1_1 in sheet Watch_1
I'm now finding that excel doesn't seem to recognise the altered name (as in Watch1_1). I'm guessing it has something to do with the scope setting which is greyed out.
Does anyone know how to fix this? Also if I just create a new named range and call it Watch1_1 it does work. In my case there are hundreds of named ranges so creating new ones would be hellish....
Is there a solution to this?
Sheet call Watch ... was copied and named Watch_1
In this sheet there are many named ranges i.e Watch1 (which is in sheet "Watch") has been renamed WatchCode1_1 in sheet Watch_1
I'm now finding that excel doesn't seem to recognise the altered name (as in Watch1_1). I'm guessing it has something to do with the scope setting which is greyed out.
Does anyone know how to fix this? Also if I just create a new named range and call it Watch1_1 it does work. In my case there are hundreds of named ranges so creating new ones would be hellish....
Is there a solution to this?