Max value index from table

[remeng]

Hi,

I have the following line of code which returns the max value in a column located within a table. This works just fine. What I'd like to do is also get the table row index for that value. How can I take the value and get the index for the row?

fred = Application.WorksheetFunction.Max(Range("non_p_plan_length_table[Min Length]"))

thanks,

Mike

 

[combo]

Range.Find returns cell(s) satysfying search criteria.

combo

 

[SkipVought]

Mike,

I'm assuming that you have a column heading Index...

Dim idx as Long
Dim xl As Application
Set xl = Application
fred = xl.Max([non_p_plan_length_table[Min Length]])
idx = xl.Index([non_p_plan_length_table[Index]], xl.Match(Fred, [non_p_plan_length_table[Min Length]],0),1)

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

 

[mintjulep]

Max might occur more than once.