title: How to create dynamic variable names VBA
body: <p>I am trying to create a dynamic number of variables in VBA based on the value in a cell.
  Essentially what I'd like to end up with is something like <code>Team1, Team2... to TeamX</code>.
  Any help is greatly appreciated</p>
  
  <pre><code>Dim i, x As Integer
  Set x = Range("J4").Value
  Dim Team(1 To x) As String
  Dim Manager(1 To x) As String
  Range("A3").Select
  For i = 1 To x
  Dim Team(i) As Integer
  </code></pre>