title: Parenthesis in string
body: <p>I'm trying to fill in a range of formulas but can't seem to find the proper way of getting parentheses in there. </p>
  
  <p>For example;</p>
  
  <pre><code>Cells(1,1).Value = "=SUMPRODUCT("
  </code></pre>
  
  <p>will return a runtime error because of the (.
  I tried a whole bunch of stuff, including;</p>
  
  <pre><code>Cells(1,1).Value = "=SUMPRODUCT" &amp; Chr(40)
  
  Cells(1,1).Formula = "=SUMPRODUCT("
  
  Cells(1,1).Value = "=SUMPRODUCT" &amp; "("
  </code></pre>
  
  <p>etc but they all seem incorrect.</p>
  
  <p>What mistake am I making and how do I get this right?</p>
  
  <p>EDIT: response to first responses</p>
  
  <p>1) I'm not talking about the solving of the sumproduct, I'm talking about entering the formula itself, from vba into excel. </p>
  
  <p>2) if I set </p>
  
  <pre><code>Cells(1,1).Value = "=SUMPRODUCT"
  </code></pre>
  
  <p>Then it works fine: my formula becomes =SUMPRODUCT
  But if I add the opening parenthesis</p>
  
  <pre><code>Cells(1,1).Value = "=SUMPRODUCT("
  </code></pre>
  
  <p>I get Run-time error '1004': Application-defined or object-defined error
  when running the sub.</p>
  
  <p>EDIT2: It seems the sumproduct formula has to be closed correctly with ")" in order not to get the runtime error. I guess I was wrongly assuming the Cells.Value was merely setting a string which would not be tested in any way.</p>