title: Need to change multiple cell names in Excel using VBA
body: <p>I have multiple cell names already created in excel. I want to add prefix to each of these names based on what sheet they are in. I'm currently using this VBA code to do so:</p>
  
  <pre><code>  Sub RenameCells() Dim n As Name
    For Each n In Sheet1.Names
        n.Name = "NLOC1_" &amp; n.Name
    Next n 
    End Sub
  </code></pre>
  
  <p>However, it does not seem to actually change the names in the sheet. I get no errors so I'm not sure what is wrong and why nothing is changing.</p>