0

I want 'vlookup' formula in Range("H1:H70") 

For i = 1 To 70
    Worksheets(1).Range("H"&i).Formula= "=VLOOKUP("F"&i;'anotherSheet'!$A:$C;2;0)"
Next i
Error 1004
  • 7,877
  • 3
  • 23
  • 46
Rob Don
  • 25
  • 1
  • 3

1 Answers1

0

The correct spelling is Sheets(1).Range("H" & i).Formula = "=VLOOKUP(F" & i & ",'anotherSheet'!$A:$C,2,0)"

Depending on your language settings you use ; as a separator when you type formulas in a worksheet, but you use , when typing formulas in VBA.

Beek
  • 376
  • 1
  • 10