How to make macro to return a value?

[Kira.SWT]

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

Please Login or Register  to view this content.

Thank you for help!!

[protonLeah]

It looks like you are traversing down column F, so Cells(i, F).Value > Cells(i + 1, F).Value Then must be written Cells(i, "F").Value > Cells(i + 1, "F").Value Then (notice the quotation marks around the F's).
If you want cell F3 to hold the value that meets the "greater than" test then use: Cells(3,"F").Value = Cells(i,"F").Value
Also, you should always use Option Explicit at the top of your module to force variable declarations. Since you did not, the VB compiler sees the F in Cells(i,F) as a variable and not a column specifier and sets its value to zero. Because there is no such thing as column zero, those lines will cause the macro to crash.

Please Login or Register  to view this content.

[Kira.SWT]

Hi Thank you alot
However when I run it, the system says that there variable not defined. Do you know why that happens??

[protonLeah]

I think it's the variable, i:

Please Login or Register  to view this content.

When you use Option Explicit, all variables must be "Dim'd" before use.