VBA Function to Find Value Matching the Max Value

[BaudJohnson]

I need to create a VBA function that takes in two arrays; the first array has the numeric values while the second array has the names. The function will find the value in the first array that is the largest and return the corresponding name (from the second array). However, I cannot use the Max function within my created function. The function also needs to begin like this:

Function FindMax(valueArray, nameArray) As String

Thanks for any help you can provide.

[Arkadi]

May I ask why you can't use the max function?

[BaudJohnson]

That was just one of the stipulations within the question given to me. But an answer using the Max function would be helpful for my understanding as well

[Arkadi]

I assume the 2 arrays have the same number of elements? and there is a reliationship between valuearray(n) and namearray(n)?

See if this works:

Please Login or Register  to view this content.

[Arkadi]

I did try something with the max function, but it didn't work as I expected, which is why I didn't post that one.
Thanks for the rep I assume it worked out for you? Please remember to mark the thread as solved if you are satisfied with the solution? Thanks