title: How to change Named Range Scope
body: <p>When I create a named range through the Name Manager, I'm given the option of specifying Workbook or <code>[worksheet name]</code> scope. But if then want to change scope, the drop-down is grayed out. Is there a way, in either Name Manager or, preferablly, VBA to change the scope of an existing named range?</p>
  
  <p>For example:</p>
  
  <ul>
  <li><code>testName</code> refers to <code>'sheet1'!A1:B2</code> with scope Workbook. How would I change that to</li>
  <li><code>testName</code> refers to <code>'sheet1'!A1:B2</code> with 'sheet1' scope?</li>
  </ul>