Hello, It was nice to know that the code worked. In the code, vlook is just a variant which will store the result of vlookup function. 'on error resume next' causes the vba code to progress to the next line whenever there is an error, without popping up any error message. So, it needs to be used carefully. In the present case, if there is an error, the error number will be stored in 'Err' and its properties (Err.number, Err.Message etc) will be available for further use. Hope it clarifies your questions.
Akhilesh Kumar Karna On Sun, Feb 8, 2009 at 2:29 AM, 2008ra...@gmail.com <2008ra...@gmail.com>wrote: > > THANK YOU VERY MUCH THAT IS REALLY PERFECT BUT CAN YOU EXPLAIN ME THAT > ABOUT "VLOOK" AND "ON ERROR RESUMEN NEXT " .PLEASE > GRACIAS > > > > --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~----------~----~----~----~------~----~------~--~---
