Get a row number from function

[daverunt]

Hi,

I am using a worksheet function to get the minimum value in a column as below. There may be 1-n rows it is looking at.
Is it possible to find which row that the minimum is found, as I would like to check the value in Column C of the same row?

    Worksheets("Sheet1").Range("D6").Value = Application.WorksheetFunction.Min(Columns("E"))

 

[RoryA]

You can use Match:

Worksheets("Sheet1").Range("D6").Value = Cells(Application.Match(Application.WorksheetFunction.Min(Columns("E")), Columns("E"), 0), "C").Value

 

[daverunt]

Hi Rory

Thanks for the reply.
I don't think that's what I am after looking at it?
I need the row because the value in it is to be checked against another cell.
The values are not related other than being in the same row.

 

[Fluff]

If you want the row number rather than the value in col C for that row try

Worksheets("Sheet1").Range("D6").Value =Application.Match(Application.WorksheetFunction.Min(Columns("E")), Columns("E"), 0)

 

[daverunt]

Time to eat crow.
This is what happens when you don't try before dismissing.

My thanks to you Rory for the better answer than I was looking for and to you Fluff for the answer I was looking for.
Both will come in handy.

 

[Fluff]

Glad we could help & thanks for the feedback