数据源
aa(1)=array( 420,0,0 )
aa(2)=array( 0,297,0 )
aa(3)=array( 0,0,0 )
aa(4)=array( 851,0,0 )
aa(5)=array( 851,297,0 )
aa(6)=array( 1271,0,0 )
aa(7)=array( 1271,297,0 )
求aa的最大值1271
或aa(ii)(0)的最大值1271
或aa(ii)(1)的最大值297
谢谢
aa(1)=array( 420,0,0 )
aa(2)=array( 0,297,0 )
aa(3)=array( 0,0,0 )
aa(4)=array( 851,0,0 )
aa(5)=array( 851,297,0 )
aa(6)=array( 1271,0,0 )
aa(7)=array( 1271,297,0 )
求aa的最大值1271
或aa(ii)(0)的最大值1271
或aa(ii)(1)的最大值297
谢谢
解决方案 »
- 第二页以上消取装订线
- 把excel导入到SQL的问题。
- 二维数组大小排序求教高手,谢谢!!!
- PICTURE控件
- daisy8675(莫依)进来
- 数据库查询代码如下,但我查找时总说没有符合条件的记录,请大家帮个小忙,走过路过,不要错过
- 如何用VB实现CMD的"net send XXX.XXX.XXX.XXX @#&$#@&$#@&$"
- (年\月\日\时)如何转变为时间?还请帮助!
- 获取系统时间(包括日期和时间:2002/12/12 12:12:12)的API??
- 关于File System Object文件操作的问题,急!!!
- 怎样修改浏览器文本输入框中的右键菜单
- 根据combox选择条件,查询excel中符合条件数据,可能查询到很多哦
dim intH as integer
dim intL as integer
dim lngMax as long
lngMax=-1
for intL=1 to 7
for intH=0 to 2
if aa(intH,intL)>lngMax then lngMax=aa(intH,intL)
next intH
next intL
debug.print lngMax
Dim i As Long
Dim a As Integer, b As Integer
For i = 0 To UBound(aa)
If aa(ii)(0) > a Then
a = aa(ii + 1)(0)
End If
Next
Debug.Print a
For i = 0 To UBound(aa)
If aa(ii)(1) > b Then
b = aa(ii + 1)(1)
End If
Next
Debug.Print b
End Sub还要第3个元素,同样.
Dim i As Long
Dim a As Integer, b As Integer
For i = 0 To UBound(aa)
If aa(ii)(0) > a Then
a = aa(ii)(0)
End If
Next
Debug.Print a
For i = 0 To UBound(aa)
If aa(ii)(1) > b Then
b = aa(ii)(1)
End If
Next
Debug.Print b
End Sub
Dim i As Long
Dim Index As Long
Index = LBound(arr)
For i = LBound(arr) + 1 To UBound(arr)
If arr(i)(Idx) > arr(Index)(Idx) Then Index = i
Next
ArrayMaxValue = arr(Index)(Idx)
End FunctionPrivate Sub Command1_Click()
Dim aa(1 To 7)
Dim i As Long
aa(1) = Array(420, 0, 0)
aa(2) = Array(0, 297, 0)
aa(3) = Array(0, 0, 0)
aa(4) = Array(851, 0, 0)
aa(5) = Array(851, 297, 0)
aa(6) = Array(1271, 0, 0)
aa(7) = Array(1271, 297, 0) For i = 0 To 2
Debug.Print ArrayMaxValue(aa, i) '再在结果中找最大值就是整个数组的最大值..略
Next
End Sub