Hi,
I just tried with ur example still it is taking more time and got the error message of script out of range.
Note: The funtion u wrote will validate between the previous value (i) and next value (i+1) which will not validate between i and i+2
EX:
Please find the below list:
amar 1
batchu 2
akbar 3
anand 4
venkat 5
The mentioned function will validate only in between 1 and 2, 2 and 3 , 3 and 4, 4 and 5 this is the way it would proceed it will not compare in between 1 and 3 , 1 and 4 . So with this the function may not fullfill the required scenario.
Can you please let me know if there is better solution aprt from this .
Please let me know if i am going in wrong direction
I just tried with ur example still it is taking more time and got the error message of script out of range.
Code:
Dim n(271)
m=Browser("……").Page("……..").Frame("……..").WebTable("……….").RowCount
msgbox m
For i=3 to m-1 step 1
n(i)=Browser("………").Page("……..").Frame("…….").WebTable("…….").GetCellData(i,2)
Call IsAscending (n)
Next
Function IsAscending(n)
'Assign default value of IsAscending
IsAscending = true
For i= 0 to m - 1
If n(i) > n(i+1) Then
'Return value of IsAscending
IsAscending = false
exit for
End If
Next
End FunctionNote: The funtion u wrote will validate between the previous value (i) and next value (i+1) which will not validate between i and i+2
EX:
Please find the below list:
amar 1
batchu 2
akbar 3
anand 4
venkat 5
The mentioned function will validate only in between 1 and 2, 2 and 3 , 3 and 4, 4 and 5 this is the way it would proceed it will not compare in between 1 and 3 , 1 and 4 . So with this the function may not fullfill the required scenario.
Can you please let me know if there is better solution aprt from this .
Please let me know if i am going in wrong direction

