|
本帖最后由 Sellby 于 2013-11-2 22:10 编辑
- <p>
- Sub 作业一()
- Dim arr(), tempArr
- Dim i As Byte, x As Byte
- With Sheets("1")
- .Columns("b:d").ClearContents
- .Columns("b:d").NumberFormatLocal = "@"
- arr = .Range("a1").CurrentRegion.Value
- x = UBound(arr)
- ReDim Preserve arr(1 To x, 1 To 4)
- For i = 1 To x
- tempArr = Split(arr(i, 1), "*")
- arr(i, 2) = tempArr(0)
- arr(i, 3) = tempArr(1)
- arr(i, 4) = tempArr(2)
- Next i
- .Range("a1").Resize(x, 4) = arr
- End With
- End Sub
- Sub 作业二()
- Dim arr(), brr(1 To 6, 1 To 4)
- Dim a
- With Sheets("2")
- arr = .Range("b2:f12").Value
- brr(1, 1) = "条件": brr(1, 2) = "个数"
- brr(1, 3) = "条件": brr(1, 4) = "个数"
- brr(2, 1) = "<100": brr(2, 3) = "<600"
- brr(3, 1) = "<200": brr(3, 3) = "<700"
- brr(4, 1) = "<300": brr(4, 3) = "<800"
- brr(5, 1) = "<400": brr(5, 3) = "<900"
- brr(6, 1) = "<500": brr(6, 3) = "<1000"
- For Each a In arr
- Select Case a
- Case Is < 100
- brr(2, 2) = brr(2, 2) + 1
- Case Is < 200
- brr(3, 2) = brr(3, 2) + 1
- Case Is < 300
- brr(4, 2) = brr(4, 2) + 1
- Case Is < 400
- brr(5, 2) = brr(5, 2) + 1
- Case Is < 500
- brr(6, 2) = brr(6, 2) + 1
- Case Is < 600
- brr(2, 4) = brr(2, 4) + 1
- Case Is < 700
- brr(3, 4) = brr(3, 4) + 1
- Case Is < 800
- brr(4, 4) = brr(4, 4) + 1
- Case Is < 900
- brr(5, 4) = brr(5, 4) + 1
- Case Else
- brr(6, 4) = brr(6, 4) + 1
- End Select
- Next
- .Range("h3").Resize(6, 4).ClearContents
- .Range("h3").Resize(6, 4) = brr
- End With
- End Sub
- Sub 作业三()
- Dim arr(), brr()
- Dim i As Byte, j As Byte, x As Byte, y As Byte
- Dim iMax As Double, iMin As Double, iAvg As Double, iSum As Double, a As Double
- With Sheets("3")
- arr = .Range("a2").CurrentRegion.Value
- x = UBound(arr): y = UBound(arr, 2)
- ReDim brr(1 To x, 1 To 5)
- brr(1, 1) = "序号"
- brr(1, 2) = "最大数"
- brr(1, 3) = "最小数"
- brr(1, 4) = "平均值"
- brr(1, 5) = "和"
- For i = 2 To x
- iMax = 0
- iMin = 1000
- iSum = 0
- brr(i, 1) = arr(i, 1)
- For j = 2 To y
- a = arr(i, j)
- iSum = iSum + a
- If a > iMax Then iMax = a
- If a < iMin Then iMin = a
- Next j
- brr(i, 2) = iMax
- brr(i, 3) = iMin
- brr(i, 4) = iSum / (y - 1)
- brr(i, 5) = iSum
- Next i
- .Range("i2").Resize(x, 5).ClearContents
- .Range("i2").Resize(x, 5) = brr
- End With
- End Sub
- Sub 作业四()
- Dim arr(), brr(), crr()
- Dim Str, uStr As String, i As Byte
-
- With Sheets("4")
- arr = .Range("c13:g27").Value
- ReDim brr(1 To 255)
- For Each Str In arr
- uStr = Asc(UCase(Str))
- If IsEmpty(brr(uStr)) Then
- brr(uStr) = Str
- i = i + 1
- ReDim Preserve crr(1 To i)
- crr(i) = Str
- End If
- Next
-
- .Range("c43").Resize(100).ClearContents
- .Range("c43").Resize(i) = Application.Transpose(crr)
- End With
- End Sub
- Sub 作业五()
- Dim arr(), brr(1 To 20), crr()
- Dim i As Byte
- Dim a
- With Sheets("5")
- arr = .Range("C9:G23").Value
- For Each a In arr
- If IsEmpty(brr(a)) Then
- brr(a) = a
- i = i + 1
- ReDim Preserve crr(1 To i)
- crr(i) = a
- End If
- Next
- .Range("l8").Resize(20).ClearContents
- .Range("l8").Resize(i) = Application.Transpose(crr)
- End With
- End Sub</p><p> </p><p>Sub 作业四2()
- Dim arr(), brr(), crr()
- Dim Str, uStr As String, i As Byte
- With Sheets("4")
- arr = .Range("c13:g27").Value
- ReDim brr(1 To 255)
- For Each Str In arr
- If InStr(uStr, UCase(Str)) = 0 Then
- uStr = uStr & "6" & UCase(Str)
- i = i + 1
- ReDim Preserve crr(1 To i)
- crr(i) = Str
- End If
- Next
-
- .Range("c43").Resize(100).ClearContents
- .Range("c43").Resize(i) = Application.Transpose(crr)</p><p> End With
- End Sub</p><p> </p>
复制代码 |
评分
-
查看全部评分
|