Phil
Forget my answer, it will not return the correct address.
I will have another look at it.

Cordially
Pascal

"papou" a écrit dans le message de news:
...
Hello Phil

Msgbox "Max value is in " & _
Evaluate("=ADDRESS(1,MATCH(MAX(I1:L1),I1:L1,0))")

HTH
Cordially
Pascal


"Phil" a écrit dans le message de news:
...
I am in need of some help regarding the creation of a simple MAX
calculation
in my code.

The data is something like the following:

Col I Col J Col K Col L
12 4 7 19

How would I write a line of code that will identify that within this
array
Column L has the largest figure?

Many thanks