you can use any Excel function in vba via
Application.WorksheetFunction.function
Application.WorksheetFunction.VLookup(arg1,arg2,arg3,arg4)
arg= parameters required in excel functions
Application.WorksheetFunction.VLookup(range(A1).value,Range(B1:D7),2,0)
Best Regards,
Anubhav
On Monday,
These Youtube Videos my might Help
http://youtu.be/nZfySb0FI8w - A VBA Formula Trick
http://youtu.be/W82P4cxVK3M - Application.WorksheetFunction
On Monday, May 14, 2012 4:23:28 AM UTC-6, Bullet wrote:
Hi All,
Can anyone explain how to use Vlookup, Index, Match, Offset function in
VBA