title: Selecting charts without referencing the chart number
body: <p>I want to select a random chart on a sheet in excel using VBA without knowing the chart number because the chart generated always changes in number. Could anyone help please? Is it possible to select a chart without referencing the chart number? I want to change the chart name of the active chart.</p>
  
  <pre><code>1   ActiveSheet.ChartObjects("Chart 409").Activate
  2   ActiveSheet.Shapes("Chart 409").Name = "Chart 1"
  3   ActiveSheet.ChartObjects("Chart 1").Activate
  </code></pre>