View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Fred Smith Fred Smith is offline
external usenet poster
 
Posts: 623
Default Worksheetfunction

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