Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
create a vlookup formula with VBA
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
create a vlookup formula with VBA
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:D; 2;FALSE)" Cells(i, 18).Formula = "=VLOOKUP(S" & i & ";Tabela!B:D; 3;FALSE)" Next -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
create a vlookup formula with VBA
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible to create a VLOOKUP formula based on an ActiveX con | Excel Worksheet Functions | |||
Create a graph from a vlookup? | Charts and Charting in Excel | |||
how do I create a vlookup? | Excel Discussion (Misc queries) | |||
XLS - HOW Do I use the results of a formula to create NAME to vlookup | Excel Programming | |||
need to create a formula to create a timesheet but haven't a clue | Excel Discussion (Misc queries) |