title: excel vba input reference cell into formula and loop
body: <p>I have what I thought was a very basic VBA challenge, and have spent hours searching for an answer. Thanks if someone can point me to the right place if already addressed.</p>
  
  <p>I have a formula that is B1 + C1 = D1, and have two 1x5 matrix of data inputs, one for cell B1 and one for cell C1, say [1,2,3,4,5] and [A,B,C,D,E], respectively, in cells (B2:B7) and (C2:C7). I would like to loop through the inputs, such that I get five unique answers [1+A, 2+B, 3+C, 4+D, 5+E], and output those answers in an adjacent 1x5 matrix, say in cells (D2:D7).</p>
  
  <p>Recording a macro does not work here, as it records a copy/paste action that is inflexible for future use (for expanded matrices, other sheet locations, more complex formulas, etc).</p>
  
  <p>Any help much appreciated.</p>
  
  <p>Henry</p>
  
  <p>UPDATE: I believe I need to be using "Do While" or some similar loop code, and additional "For" and "Next" coding.</p>
  
  <p>UPDATE: Here is a step-by-step picture of what I am trying to do with the code:
  <a href="https://i.stack.imgur.com/bO0WR.png" rel="nofollow noreferrer">step-by-step process results image</a></p>