title: Excel VBA Formula not working in German excel
body: <p>I dont know why this formula is not working. Any help (german version of excel 2007)</p>
  
  <pre><code>Private Sub Worksheet_SelectionChange(ByVal Target As Range)    
  Dim Calc As Double    
  Calc = 1.5    
  Range("A2").Formula = "= B2 *C2 * &amp; Calc &amp; "    
  End Sub
  </code></pre>
  
  <p>I want to use formula . without .formula it works.</p>