| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Built in Functions in VB Code
I apologize if this is some trivial question that has an easy answer, but I
have been through help and 2 different Excel VB books and cannot get this to work. Problem: In a VB Function, I would like to do the following: Pos = VLookup(InValue, NamedTable, 2, FALSE) The debugger won't let me use VLookup. I also tried Average, etc., and the debugger pops on whatever built-in function I use. Is there a flag I can set, or a technique I need to use to make this work? I really know excel, but am a novice at VB. I can get around it nesting vlookups in the spreadsheet, but it is really ugly. Being able to do this would enable me to clean up my code a bunch. I would welcome feedback. Regards, Jim -------------- Jim Conrady |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| language of built-in functions | Excel Discussion (Misc queries) | |||
| Can I do this with built in functions? | Excel Worksheet Functions | |||
| How do I use Excel Built-In Functions in Code? | Excel Worksheet Functions | |||
| Viewing built-in functions | Excel Programming | |||
| Using Built in Functions in VBA Code | Excel Programming | |||
Threaded Mode
