Hi,

I want to introduce 3 formulas in a range.the code is below and it
always gets stuck in the vlookup formulas. I must be blind because I
cannot see the error.
thanks a million

PA


For i = 8 To 100
Cells(i, 19).Formula = "=VALUE(T" & i & ")"
Cells(i, 17).Formula = "=VLOOKUP(S" & i & ";Tabela!B:D;
2;FALSE)"
Cells(i, 18).Formula = "=VLOOKUP(S" & i & ";Tabela!B:D;
3;FALSE)"
Next