Thu 1 May 2008, 16:52Delegate Elina said...
Elina has attended:
Excel VBA Intro Intermediate course
Excel VBA Intro Intermediate course
Index formula
How can one create index/match formula in VBA?
Thu 12 Jun 2008, 10:45
Edited on Thu 12 Jun 2008, 10:46Trainer Stephen said...
RE: index formula
Hi Elina
Thank you for your question
All of the worksheet functions are accessable as methods of the application object
For example
V1 = Application.Worksheetfunction.Match(Arg1,Arg2..)Returns the result of the match function, (with arg1, arg2 etc. replaced by the relevant arguments) to the variable v1
This same technique will work for any of Excel's standard worksheet functions
Hope this is helpful, please feel free to get in touch if you require anything else
Regards
Stephen
