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