title: SeriesCollection.Name to Range? Excel
body: <p>I'm attempting to get a proper legend from my excel sheet and I'm attempting to create the legend using the </p>
  
  <pre><code>SeriesCollection(1).Name
  </code></pre>
  
  <p>Method in VBA. What I'm doing looks like this</p>
  
  <pre><code>ActiveChart.SeriesCollection(1).Name = Range(" some range ").Text
  </code></pre>
  
  <p>This however gives me the error of Type Mismatch. Any ideas on what the issue is? Or how I can go about doing this a different way?</p>