title: Call Macro(i) (For loop)
body: <p>I can't seem to find anything on the web for this. I am wondering if there is a way to call a <strong>loop</strong> of macro's. I have <strong>Macro1() - Macro16()</strong> and I want to run them consecutively based on the value in another cell. Using this code causes a compile error:</p>
  
  <blockquote>
    <p>Sub or Function not defined.</p>
  </blockquote>
  
  <p>Can this be achieved?</p>
  
  <pre><code>Sub PlotAll()
      Dim i As Integer
      Application.ScreenUpdating = False
      If Sheet1.Range("T66") &lt;&gt; 0 Then
          For i = 1 To Sheet1.Range("T66") ' T66 is number of Macro's to perform
              Call Macroi
          Next i
      Else
          MsgBox "You do not have any points to plot.", vbExclamation
      End If
      Application.ScreenUpdating = True
  End Sub
  </code></pre>