title: Excel VBA "compile error expected end of statement" (Parenthesis issue)
body: <p>I tried below code in excel vba and always getting error</p>
  <blockquote>
  <p>excel vba compile error expected end of statement</p>
  </blockquote>
  <pre><code>Range(&quot;O1&quot;).Value = &quot;=MID(A1,FIND(&quot;(&quot;,A1)+1,FIND(&quot;)&quot;,A1)-FIND(&quot;(&quot;,A1)-1)&quot;
  </code></pre>
  <p>And when I try to solve it with Double quote below</p>
  <pre><code>Range(&quot;O1&quot;).Value = &quot;=MID(A1,FIND(&quot;&quot;(&quot;&quot;,A1)+1,FIND(&quot;&quot;)&quot;&quot;,A1)-FIND(&quot;&quot;(&quot;&quot;,A1)-1)&quot;
  </code></pre>
  <p>Then the formula that appear in cell &quot;O1&quot; is</p>
  <pre><code>=MID(A1,FIND(&quot;(&quot;,A1)+1,FIND(&quot;)&quot;,A1)-FIND(&quot;(&quot;,A1)-1)
  </code></pre>
  <p>And formula doesn't work because it find &quot;(&quot; instead of just find only (</p>