Thanks Niek I just make it work; what I meant that the "on error" was
not making his function the message appear even thou I had the "on
error resume next", The problem was that I had "on error goto 0" I
think that was the problem.

Niek Otten ha escrito:

Please supply your code, formula and values of the arguments. And what "does not work" mean? How do you notice? We're not
clairvoyant!

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


wrote in message ps.com...
| Hi all I am using a vLookup with a worksheetFunction the thing is that
| when it does not find the value it send an error "I can not find the
| property value"; what I want is to skip the error I try to use an error
| resume next but it does not work.
|
| Any Ideas
|
| Thanks in advance
|
| Gaston
|