How to create dynamic variable names VBA
<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>