title: Giving formula to a cell which has Unknown Range [ERROR]
body: <p>I'm basically trying to give a formula to a cell including unknown range. But I'm keep getting error. "inpt1" changes according to inpt1's count so I cannot formulate that. As inpt1 changes I cannot control the sum formula due to its range changes as well. Let me illustrate;</p>
  
  <pre><code>Cells(inpt1 + 3, 4).Formula = "=SUM(" &amp; Range(Cells(3, 9), Cells(inpt1 + 2, 9)) &amp; ")"
  </code></pre>
  
  <p>I added an example image for you guys to understand it better.</p>
  
  <p><a href="https://i.hizliresim.com/LDJ0rz.png" rel="nofollow noreferrer">Try to sum the prices of I3:I5 &amp; write it as a formula in green area in the picture</a></p>