title: VBA how to create variable name containing variable
body: <p>I have a macro with a variable number of players (1 and up). These players should be Player1, Player2, etc. How can I create variable names "on the fly"?</p>
  
  <p>The best I can think of is something like this:
      a=a+1
      Dim Player&amp;(a) </p>