return cell address

Address Of First Minimum In A Range

To return the address of the cell containing the first (or only) instance of the minimum of a list,
use the following array formula:

=ADDRESS(MIN(IF(NumRange=MIN(NumRange),ROW(NumRange))),COLUMN(NumRange),4)

This function returns B2, the address of the first '1' in the range.

http://www.cpearson.com/excel/excelF.htm

this is an array formula you will be required to
press ctrl shift enter ( instead of just enter)
to execute it, don't know if it works for various columns though

Originally Posted by missing

help

This site will help
http://support.microsoft.com/kb/213375

the code below is what you want

Function MinAddress(The_Range)

   ' Sets variable equal to minimum value in the input range.
   MinNum = Application.Min(The_Range)
   ' Loop to check each cell in the input range to see if equals the
   ' min variable.
   For Each cell In The_Range
      If cell = MinNum Then
         ' If the cell value equals the max variable it
         ' returns the address to the function and exits the loop
         MinAddress = cell.Address
         Exit For
      End If
   Next cell

End Function

hit alt F11 then insert,module, copy and paste the code there
next use the formula
=minaddress(A1:C3)
to get the address of the min value of that range