Custom Search

Friday, June 29, 2012

How to get highest value from given values


Dim num, i, Length1
num=array(100,34,12,98,43,89,49,56)
Length1 = UBound(num) 'Find the length of array
For i= 1 to Length1
   If (num(i)>num(0)) Then
     num(0)=num(i)
   End If
Next
MsgBox num(0)

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.