But a more likely cause is that Find doesn't work in a UDF used in a
worksheet in xl2000 and earlier.

--
Regards,
Tom Ogilvy

"Ron Rosenfeld" wrote in message
...
On Thu, 8 Dec 2005 19:48:12 -0500, "JMay" wrote:

Trying this -- I get #VALUE! as a result...
Any suggestions?
Tks..

An error value in rg will cause that.








"Ron Rosenfeld" wrote in message
.. .
On Sun, 11 Dec 2005 16:06:40 -0000, "Mike H"
wrote:

Hello, I want a function that allows me to enter a range and then
returns
the address of the cell with the minimum value. It is the Address I am
interested in, not the value.

Any ideas?

Many thanks


Since I see this post in programming, I will assume you want a VBA
solution:

====================================
Option Explicit
Function MinCellAdr(rg As Range) As String
Dim MinNum As Double
MinNum = Application.WorksheetFunction.Min(rg)

MinCellAdr = rg.Find(what:=MinNum, _
LookIn:=xlValues, lookat:=xlWhole).Address

End Function
=====================================


--ron


--ron