|
本帖最后由 爱疯 于 2011-9-5 08:19 编辑
海贼乔巴 发表于 2011-9-5 00:05
版主,求回话
5楼的压缩文件包是正常的,可以解压。
这是从5楼文件里复制出的代码:
- Private Sub an_Click()
- For x = 2 To [d65536].End(xlUp).Row
- If Cells(x, 4) = TextBox1 Then
- n = n + 1
- End If
- Next
- If n > 1 Then
- MsgBox "有重复"
- Else
- MsgBox "没有重复"
- End If
- End Sub
- Sub 查找()
- End Sub
- Private Sub CommandButton1_Click()
- Range("f8:g10000").ClearContents
- Dim arr
- Dim arr1(1 To 10000, 1 To 2)
- Dim x, y, m, n
- arr = Range("d2:d" & Range("d65536").End(xlUp).Row)
- For x = 1 To UBound(arr, 1)
- For y = 1 To UBound(arr, 1)
- If arr(x, 1) = arr(y, 1) Then
- n = n + 1
- End If
- Next
- If n > 1 Then
- m = m + 1
- arr1(m, 1) = arr(x, 1)
- arr1(m, 2) = x + 1
- End If
- n = 0
- Next
- If arr1(1, 1) = "" Then
- MsgBox "没发现重复数据"
- Else
- Range("f8").Resize(m, 2) = arr1
- End If
- End Sub
复制代码
|
|