Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
What's the difference between Application.WorksheetFunction.Vlookup and
Application.Vlookup? As far as I can tell they both work. However, one difference I've found is that when the Vlookup fails, Application.WorksheetFunction.Vlookup returns nothing, but Application.Vlookup returns N/A. Is there any need to use WorksheetFunction? It would save a lot of typing if I didn't have to use it. -- Regards, Fred Please reply to newsgroup, not e-mail |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
WorksheetFunction help | Excel Discussion (Misc queries) | |||
Can't use WorksheetFunction | Excel Discussion (Misc queries) | |||
Max WorksheetFunction | Excel Programming | |||
WorkSheetFunction.CountIf & WorkSheetFunction.SumIf with 2 conditions? | Excel Programming | |||
WorksheetFunction | Excel Programming |