| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
what is the VBA code for VLOOKUP?
Hi all,
i'm a newbie to excel... i m looking for VBA code for VLOOKUP function anyone can help? any good website recommend? pls kindly help! thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
what is the VBA code for VLOOKUP?
Range("F12").Value = Application.VLookup(vVal, _
Worksheets("Sheet1").Range("A1:F500"), 2,False) -- Regards, Tom Ogilvy "Shan" wrote in message ... Hi all, i'm a newbie to excel... i m looking for VBA code for VLOOKUP function anyone can help? any good website recommend? pls kindly help! thanks! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
what is the VBA code for VLOOKUP?
Application..VLOKUP(Range("A1"),Range("H1:J100"),2 ,False)
as an example -- HTH RP (remove nothere from the email address if mailing direct) "Shan" wrote in message ... Hi all, i'm a newbie to excel... i m looking for VBA code for VLOOKUP function anyone can help? any good website recommend? pls kindly help! thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup VBA code | Excel Discussion (Misc queries) | |||
| VLOOKUP as a vb code | Excel Discussion (Misc queries) | |||
| Using VLOOKUP in VBA code | Excel Worksheet Functions | |||
| Vlookup in VB code | Excel Programming | |||
| Help with Vlookup code | Excel Programming | |||
Linear Mode
