I was helping a friend to get a vlookup done through vba. In my entire code, i have this code line for vlookup -However, if the value is not available, i get an error - Unable to get the vlookup property of the worksheetfunction class (runtime error 1004).
Please Login or Register to view this content.
I tried usingBut its not working.Please Login or Register to view this content.
Please assist.
Last edited by arlu1201; 02-23-2012 at 11:48 AM.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi Arlette
try
or use On Error Resume NextPlease Login or Register to view this content.
Thanks so much. The on error did the trick.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks