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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top