Let me try and clarify my need. I have four columns of data A - D. In column
D there is a number of minimum value (the row location varies). I actually
need the values in columns A,B & C that fall on the same row as this number
of minimum value in row D. This code will be imbedded into a macro so that
the calculations are done automatically.
"g_noggle" wrote:

I have a column of numbers and within this column of numbers there is a
number of minimum value. I need a macro that will select the location "row"
of the cell that contains this minimum value.