Varuni has attended:
Excel VBA Intro Intermediate course
VBA - vlookups
Can you use vlookups within VBA - at the moment i dont use VBA, just use combinations of vlookup etc in excel to get what i want.
RE: VBA - vlookups
Hi Varuni,
Thank you for your question.
The Vlookup worksheet function is available under the WorksheetFunction object in VBA.
You can use most built-in worksheet functions in a macro by calling the function as a method of the Application object or the WorksheetFunction object. So if you are trying to create a Vlookup then type:
worksheetfunction.vlookup(then the arguments)
I hope this answers your question.
Regards
Simon
RE: VBA - vlookups
Hi Varuni,
Thank you for your question. Your question about using Vlookups in VBA.
I replied to you early April with the following text:
---------------------------------------------------------------------
Hi Varuni,
Thank you for your question.
The Vlookup worksheet function is available under the WorksheetFunction object in VBA.
You can use most built-in worksheet functions in a macro by calling the function as a method of the Application object or the WorksheetFunction object. So if you are trying to create a Vlookup then type:
worksheetfunction.vlookup(then the arguments)
I hope this answers your question.
Regards
Simon
-----------------------------------------------------------------------
Can I confirm whether this response has answered your question?
Regards
Simon
