So I want to go down a column and compare cells.
I know alot of C programming but not much VBA.
So here is a flow of what I want.
Lets Say
Basically keep looping and working down the Column until the next spot it larger than previous then exit the loop.
P= blank array
X= Cell Value A1
Y= Cell A2
IF X <Y Then
Y stored in P exit
Else Y+1 =Y(Meaning A3)
Return to IF
Basically keep looping and working down the Column until the next spot it larger than previous then exit the loop.
I know alot of C programming but not much VBA.
So here is a flow of what I want.
Lets Say
Basically keep looping and working down the Column until the next spot it larger than previous then exit the loop.
P= blank array
X= Cell Value A1
Y= Cell A2
IF X <Y Then
Y stored in P exit
Else Y+1 =Y(Meaning A3)
Return to IF
Basically keep looping and working down the Column until the next spot it larger than previous then exit the loop.