Hi,
I'm not sure how to reference the loop to where it changes not only the cell it's pasted in, but also the formula itself.
The formula I'm trying to loop:
My Best Guess:
Thanks!
I'm not sure how to reference the loop to where it changes not only the cell it's pasted in, but also the formula itself.
The formula I'm trying to loop:
Code:
Sheets("Inputs").Range("D11").Formula = "=IFERROR(VLOOKUP(A11,LoadAnswerFields!E:F,2,FALSE),"""")"
My Best Guess:
Code:
Dim i as long
For i = 11 To 42
Sheets("Inputs").Range("D" & i).Formula = "=IFERROR(VLOOKUP(A & i,LoadAnswerFields!E:F,2,FALSE),"""")"
Next i
Thanks!