thanks, both of you, ended up getting this from your help.

application.worksheetfunction.match(application.wo rksheetfunction.max(range("c23:k23")),range("c23:k 23"),0)

--


Gary


"Trevor Shuttleworth" wrote in message
...
Gary

=MATCH(MAX(A:A),A:A,0)

will return the row number of the maximum value in column A

=MATCH(MIN(A:A),A:A,0) for the minimum

Regards

Trevor


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
is there an easy way to return the address of the min or max result? if it's
a lot of code, i'm not going to worry about it, it's not that important. but
if there's an easy way, i'd like to know.

thanks

--


Gary