create a vlookup formula with VBA

  • Thread starter Thread starter PA
  • Start date Start date
P

PA

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