Try some code like

Dim R As Range
Set R = Range("C5:C10") '<<< CHANGE
Set R = R.Offset(Application.Match( _
Application.Min(R), R, 0) - 1, 0).Resize(1, 1)
Debug.Print R.Address

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)







On Thu, 3 Sep 2009 13:21:46 -0400, "William Wolfe"
wrote:

I am running VB code in Excel 2007. I execute a min function and now I want
to know what cell contained the min value.

How do I do this?

Thanks,