return cell address

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

Originally Posted by missing

i don't know what i do wrong So i attach a file. Can you look it?

Try using formula provided by dadylonglegs and make sure that you hit CTR+SHIFT+ENTER not just ENTER.