|
感谢疯子学委指出问题,最后两题代码改进如下,改进后避免了数组重复定义:- Sub 作业四()
- Dim arr, brr(), ar, i%, n%
- arr = Range("c13", Cells(Rows.Count, 7).End(xlUp))
- ReDim brr(0)
- For Each ar In arr
- For i = 0 To n
- If UCase(brr(i)) = UCase(ar) Then GoTo 100
- Next
- brr(n) = ar
- n = n + 1
- ReDim Preserve brr(n)
- 100:
- Next
- [c43].Resize(n) = Application.Transpose(brr)
- End Sub
复制代码- Sub 作业五()
- Dim arr, brr(), ar, i%, n%
- arr = [c9].CurrentRegion
- ReDim brr(0)
- For Each ar In arr
- For i = 0 To n
- If brr(i) = ar Then GoTo 100
- Next
- brr(n) = ar
- n = n + 1
- ReDim Preserve brr(n)
- 100:
- Next
- [l8].Resize(n) = Application.Transpose(brr)
- End Sub
复制代码 |
|