Max = a(LBound(a)) For i = LBound(a) + 1 To UBound(a) If Max < a(i) Then Max = a(i) Next FindMax = Max End Function
Sub Form_Click() Dim a(100) For i = 0 To 100 a(i) = i Next Print FindMax(a()) End Sub
Thanks a lotFunction Sum(ParamArray args() As Variant) As Double ~~~~~~~~~~是否必须? Dim i As Integer ' All ParamArrays are zero-based. For i = 0 To UBound(args) Sum = Sum + args(i) Next End Function
Dim Max, i
Max = a(LBound(a))
For i = LBound(a) + 1 To UBound(a)
If Max < a(i) Then Max = a(i)
Next
FindMax = Max
End Function
Sub Form_Click()
Dim a(100)
For i = 0 To 100
a(i) = i
Next
Print FindMax(a())
End Sub
~~~~~~~~~~是否必须?
Dim i As Integer
' All ParamArrays are zero-based.
For i = 0 To UBound(args)
Sum = Sum + args(i)
Next
End Function