WorksheetFunction.VLookup doesnt work if result is #N/A

Greetings,
1- Open enclosed file.
2- Run Macro1.

Please Login or Register  to view this content.

3- See that error picture in the following link;
http://i.cubeupload.com/7bc7dw.jpg

Any idea will be appreciated...Thanks in advance...

Please Login or Register  to view this content.

Regards, TMS

When called from VBA, Excel functions do not simply return their associated errors. They cause VBA to "crash".

What you need to do is use normal error handling (On error statements etc. see http://www.cpearson.com/excel/ErrorHandling.htm ) in anticipation of the error.

If I understand what you want to do, it appears that you simply need an On error goto exit1 to enable the appropriate error handler.

Thanks TMS,
Thanks MrShorty,
Solved.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Regards, TMS

You're welcome. Thanks for the rep.

Hi again,
I am so sorry but this issue is not exactly solved.

So, please open enclosed file,
Run Macro1,
Then please tell me why there is an error there.
Regards

Please Login or Register  to view this content.

Regards, TMS


Regards, TMS

It looks solved. Thanks.

It looks solved.

AFAICS, it is.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.