Yes Roger it would.
Since our friend did not specify (although it seems from his original post
that he is looking in a row), he may need to amend to his needs.

Cordially
Pascal

"Roger Govier" a écrit dans le message de
news: ...
Hi Pascal

Wouldn't that return the address of the highest value in row 1, even it
were outside the range that the OP wanted?

--
Regards

Roger Govier


"papou" wrote in message
...
Ok, this should work better:
MsgBox "Max value is in " & _
Evaluate("=ADDRESS(ROW(A1),MATCH(MAX(1:1),1:1,0))" )

HTH
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