title: Range accepts sometimes only semicolons instead of commas
body: <p>I have reduced my problem to the following code example. I am using a German Excel version in which separators in normal Excel formulas are semicolons ";" instead of "," (e.g. <code>=SUMME(A1;A3)</code> instead of <code>=SUM(A1,A3)</code>). <br> 
  Now the code which works different from time to time:</p>
  
  <pre><code>Sub CommasDoNotWorkAnymore()
  
  Dim a()
  Dim i%
  
  a = Array("A1,A3,A5", "B1", "B2")
  i = 0
  
  Debug.Print Sheets(1).Range(a(i)).Address
  End Sub
  </code></pre>
  
  <p>Normally, when starting Excel, this code works. But sometimes Excel seem to switch the accepted separators used in the <code>Range()</code> to semicolons untill I restart Excel. This occurs most times when rerunning the code after a runtime error.</p>
  
  <p>Is this a general Excel bug? Does anybody know what is behind this behaviour? Is there some Excel-wide "local option" for the <code>Range</code> class?</p>
  
  <p>EDIT: I just tried to convert the <code>a(i)</code> with <code>CStr(a(i)</code> but this does also not work. So no ByRef kind of problem...</p>