Posted to microsoft.public.excel.programming

PA[_2_]

external usenet poster

Posts: 15

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Is it possible to create a VLOOKUP formula based on an ActiveX con	Srisuephanh	Excel Worksheet Functions	1	October 19th 07 04:41 AM
Create a graph from a vlookup?	Sean	Charts and Charting in Excel	1	July 28th 07 02:38 PM
how do I create a vlookup?	Jamie	Excel Discussion (Misc queries)	3	February 1st 06 08:29 PM
XLS - HOW Do I use the results of a formula to create NAME to vlookup	Clive Geezer	Excel Programming	1	November 26th 05 03:04 PM
need to create a formula to create a timesheet but haven't a clue	AHurd	Excel Discussion (Misc queries)	7	August 22nd 05 12:04 PM

All times are GMT +1. The time now is 06:54 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us