VBA - vlookups

Resolved · Medium Priority · Version 2007

Tue 31 Mar 2009, 16:39 Delegate Varuni said...

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.

Thu 9 Apr 2009, 10:28 Trainer Simon said...

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

Wed 15 Apr 2009, 09:34 Trainer Simon said...

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