Hi guys, I am new in Excel VBA and for the experiment data, I want to find the first number that is bigger than the next one, and i want it to show on a blank cell. How can I achieve this?
The following is the code I wrote
Thank you for help!!Sub find_yeild_stress() For i = 19 To 83 If Cells(i, F).Value > Cells(i + 1, F).Value Then Cells(3, f).Copy.Cells(i, F).Value End If Next i End Sub
Bookmarks