I am pretty sure that if you create a named range (through VBA) with a value for “RefersToR1C1” that is not in the form of “R1C1” you will get a "Catastrophic Error"...whic is ominous to read and difficult to undo.
All my sheets were duplicated in the VBA explorer window, so I had to go back...