| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vlookup in user defined function
I have a user defined function, but Vlookup doesnt work in
it. This i the part in the function that doesn't work... any ideas? thanks /Tim Function test(value, table) test = VLookup(value, table, 2, False) End Function |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Vlookup in user defined function
I think you need ot qualify it fully, as in
test = Application.WorksheetFunction.VLookup(value, table, 2, False) "Tim Svensson" wrote in message ... I have a user defined function, but Vlookup doesnt work in it. This is the part in the function that doesn't work... any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| User Defined Function and VLookUP | Excel Worksheet Functions | |||
| user defined function | Excel Worksheet Functions | |||
| User Defined Function | Excel Worksheet Functions | |||
| vlookup, add parameter, on error return user defined value | Excel Worksheet Functions | |||
| User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming | |||
Hybrid Mode
