VBA: For Loop through column to match a certain value

[iand5]

I have the following code to calculate the maximum value:

 Windows("Schedule.xlsx").Activate
   Sheets("RESOURCE").Select
    Range("AX6:AX32").Select
    Range("AX32").Activate
    ActiveCell.FormulaR1C1 = "=MAX(R[-26]C:R[-3]C)"
    Range("AX32").Select
    Max = Range("AX32").Value  'Max is a variable that stores the max value

I want to iterate through "AX6:AX32" to find the exact row that stores the maximum value.

 

[JackDanIce]

Try:

Sub MaxVal()

    Dim Max As Long
    
    With Workbooks("Schedule.xlx").Sheets("RESOURCE").Range("AX6:AX32")
        MsgBox .find(Application.Max(.Value), , xlValues).row
    End With
    
End Sub

It may be .Range("AX6:AX29") looking at your formula...