I want to write a function in VBA which multiplies two numbers together as
follows

=Multiply(A,B,5)

A is the first value
B is the array, eg. A1:A10
5 is the 5th value of the array.

Would anybody be able to help me with this ?

Thanks