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;
2;FALSE)"
Cells(i, 18).Formula = "=VLOOKUP(S" & i & ";Tabela!B;
3;FALSE)"
Next

Change your semicolons to commas.

VBA is USA centric. But when the formulas are plopped into the cell, all will
be ok with the world.

PA wrote:
>
> 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;
> 2;FALSE)"
> Cells(i, 18).Formula = "=VLOOKUP(S" & i & ";Tabela!B;
> 3;FALSE)"
> Next

--

Dave Peterson

Try replacing the semicolons with commas.
--
Jim Cone
Portland, Oregon USA



"PA"
wrote in message
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; 2;FALSE)"
Cells(i, 18).Formula = "=VLOOKUP(S" & i & ";Tabela!B; 3;FALSE)"
Next