|
A组长:wenchduan- Sub 数组作业题1()
- Dim ARR, X As Integer, y As Integer
- ARR = Range("a1:D17")
- For X = 1 To UBound(ARR)
- For y = 1 To UBound(ARR, 2)
- If ARR(X, y) < 0 Then ARR(X, y) = 0
- Next y
- Next X
- Range("G1").Resize(17, 4) = ARR
- End Sub
- Sub 数组作业题2()
- Dim arr1(1 To 10000, 1 To 1), k%
- Dim ARR, X As Integer, y As Integer
- ARR = Range("a1:D17")
- For X = 1 To UBound(ARR)
- For y = 1 To UBound(ARR, 2)
- If ARR(X, y) < 0 Then
- k = k + 1
- arr1(k, 1) = ARR(X, y)
- End If
- Next y
- Next X
- Range("m1").Resize(k, 1) = arr1
- End Sub
复制代码 |
评分
-
查看全部评分
|