View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike Rediger Mike Rediger is offline
external usenet poster
 
Posts: 3
Default Function Add-in troubleshooting-Vlookup

I use Vlookup extensively and attempted to add a new function, Vlook.

The function should 1) set the 4th argument to false, and 2) return an empty
string if the regular formula would return an error.

#2 is what I'm having a problem with.

Here's my code

Function vlook(cell,range,column)
vlook = Application.WorksheetFunction.vlookup(cell,range,c olumn,FALSE)
if Application.WorksheetFunction.IsError(vlook) then vlook = ""
End Function


The code works for non-errors, however, returns #VALUE! instead of "" if the
formula cannot be resolved.

Help!