Hi all,

I have code like;

Sub Compare()
    Sheets("Sheet2").Select
    EstMax = 0
    For i = 2 To 62
        If Cells(i, 2) > EstMax Then
        EstMax = Cells(i, 2)
        End If
    Next i
    
    MsgBox EstMax
            
End Sub
and I want the select the cell that was found as "EstMax" above

And then can I use following code to make a comparision?

RealMax=0

If ActiveCell.Offset(0,1) < Cells(10,10) Then
RealMax= EstMax
Else
EstMax.ClearContents
End If

Assume that EstMax is located Cell(10,8) and Cell(10,9)=13 and Cell(10,10)=10

Thanks in advance