Vanzuck
03-27-2019, 08:18 AM
I've 2 questions I'm not able to solve from myself
They regard the usage of Vlookup in VBA, within an Excel module.
First question: I do want just to have the row number of the item found
Second question: what is the easiest way to manage the "Found/Not Found" ?
I did the following but, I'm not proud of it:
LookedItem = "Not Found"
On Error Resume next
LookedItem = Application.WorksheetFunction.Vlookup(arguments)
thanks
They regard the usage of Vlookup in VBA, within an Excel module.
First question: I do want just to have the row number of the item found
Second question: what is the easiest way to manage the "Found/Not Found" ?
I did the following but, I'm not proud of it:
LookedItem = "Not Found"
On Error Resume next
LookedItem = Application.WorksheetFunction.Vlookup(arguments)
thanks