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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Adam" wrote in message
...
Is there a way to return the column where the min or max exists rather
than
returning the min or max? I am using WorksheetFunction.Min. Thank you
very
much.