vlookup

[Nightmare_1]

Deer all,

I'm new in the VBA and i want to ask you if it possible to include the vlookup in the VBA?

Thanks in advance

 

[Joe4]

Welcome to the Board!

Yes, you can use the VLOOKUP function in VBA by prefacing it with: Application.WorksheetFunction, i.e.

Application.WorksheetFunction.VLOOKUP(...)

See: Application.WorksheetFunction property (Excel)

 

[Nightmare_1]

Welcome to the Board!

Yes, you can use the VLOOKUP function in VBA by prefacing it with: Application.WorksheetFunction, i.e.

Application.WorksheetFunction.VLOOKUP(...)

See: Application.WorksheetFunction property (Excel)

thank you

 

[Joe4]

You are welcome.
Glad I was able to help!

You can use most Excel functions in VBA using this, though not all.