title: How to solve VBA Paste formula error 1004 and subscript out of range
body: <p>Trying to paste below formula in excel but it shows </p>
  
  <blockquote>
    <p>error 1004</p>
  </blockquote>
  
  <p>Actual Formula: </p>
  
  <pre><code>="Fixed Text: Fixed Text="""&amp;C3&amp;""", Fixed Text="""&amp;D3&amp;""", Fixed Text="&amp;E3&amp;", Fixed Text="&amp;F3&amp;", Fixed Text="&amp;", Fixed Text, Fixed Text="&amp;I3&amp;", Fixed Text="&amp;J3&amp;", Fixed Text"""&amp;K3&amp;""";{"&amp;A3&amp;"}"
  </code></pre>
  
  <p>Tried VBA Code:</p>
  
  <pre><code>Worksheets (" Fixed Text").Range (A2).Formula="=CHR(34)Fixed Text: Fixed Text=CHR(34)CHR(34)CHR(34)&amp;C3&amp;CHR(34)CHR(34)CHR(34), Fixed Text=CHR(34)CHR(34)CHR(34)&amp;D3&amp;CHR(34)CHR(34)CHR(34), Fixed Text=CHR(34)&amp;E3&amp;CHR(34), Fixed Text=CHR(34)&amp;F3&amp;CHR(34), Fixed Text=CHR(34)&amp;CHR(34), Fixed Text, Fixed Text=CHR(34)&amp;I3&amp;CHR(34), Fixed Text=CHR(34)&amp;J3&amp;CHR(34), Fixed TextCHR(34)CHR(34)CHR(34)&amp;K3&amp;CHR(34)CHR(34)CHR(34);{CHR(34)&amp;A3&amp;CHR(34)}CHR(34)"
  </code></pre>