title: Find and activate named range in Excel without knowing Worksheet name
body: <p>I'm writing a macro that will update a bunch of workbooks.</p>
  
  <p>Assume the workbook is already open.</p>
  
  <p>I need to activate (or select, either one) a cell that has a name (named range) but the kicker is that I don't know what worksheet it is in.</p>
  
  <p>In other words:
  I am guaranteed that:</p>
  
  <ul>
  <li>The named range exists.</li>
  <li>The named range is globally unique to the open workbook.</li>
  </ul>
  
  <p>I am not guaranteed that:</p>
  
  <ul>
  <li>The named range will be in the same worksheet index.</li>
  <li>The worksheets will be named the same between workbooks.</li>
  </ul>
  
  <p>Any advice will be appreciated, even one that shows me how to back into a worksheet from a global named range since that will be enough for me to then activate the worksheet and go from there. But ideally the solution will show me how to activate/select/update (the final result would be that I update the cell, or insert rows below if that helps) a named range cell without knowing the worksheet name.</p>
  
  <p>I am doing this in Excel 2007</p>
  
  <p>Thanks!</p>