vLookup Problem
 

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

vLookup Problem
 

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
|

vLookup Problem
 

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
|