Hi all,
I have code like;
and I want the select the cell that was found as "EstMax" above![]()
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 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
Bookmarks