Row Location of Maximum Value in a Column

[tharrington]

I want to find the location of the max value of a column.

My code

Dim rownum As Long
rownum = Application.worksheetfunction.match(.max("O:O"),"O:O")

Not working

Thanks

 

[Joe4]

Using the method Kenneth Hobson shows here: https://www.mrexcel.com/forum/excel...mber-maximum-value-range-vba.html#post4701966
try:

Dim rownum As Long
rownum = Range("O:O").Find(WorksheetFunction.max(Range("O:O"))).Row
MsgBox rownum