title: VBA Public Array : how to?
body: <p>So today's problem is getting me mad because that should be easy and i can not find the answer :</p>
  
  <p>How to declare a public array in VBA ? I'm using an array with the letters A, B, C,... because i'm working with Excel cells, and i don't want to declare it in every function i create, right ?
  I've tried to look on the web first and i read that you have to declare it in a different module, so that's what i've done :</p>
  
  <pre><code>Public colHeader As String
  colHeader = Array("A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L")
  </code></pre>
  
  <p>But Visual Basic doesn't like it...</p>
  
  <p>So what shall i do ?</p>
  
  <p>Thank's a lot :)</p>
  
  <p>Edit : the problem is more about asigning values to the array than to declare it</p>